how do i Reference tables in one work sheet to another?

mella

New member
Joined
Jan 20, 2012
Messages
1
Reaction score
0
Points
0
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

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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)
 
Top