PDA

View Full Version : how do i Reference tables in one work sheet to another?



mella
2012-01-20, 03:03 AM
Hi,

I'm having a bit of trouble trying to reference tables in one of my work sheets to my other work sheet. I then need to use vlookup to fill the data in the cells on my second spread sheet to my first. Can someone please tell me what i need to do? I'm having one of those days where i can't get anything to work.
Thanks

Ken Puls
2012-01-20, 07:07 PM
If you're using a VLOOKUP against a range in another sheet, it would look something like this:

=VLOOKUP(B1,Sheet1!C20:E30,3,FALSE)

The key is that the other sheet is referred to as SHEETNAME!address

If the sheet name has spaces in it then you need to add an apostrophe before and after the name (but before the !):

=VLOOKUP(B1,'My Sheet'!C20:E30,3,FALSE)