VLookups across tabs in the same worksheet

[kyaba]

Hi I am a newbie to Mr.Excel and have a question about VLookups across tabs in the same worksheet.

I am trying to do the following:

• Look up values in a data dump and pull values by unique identifier to populate cells in another tab.
• There can be multiple values for the same unique identifier.

I have tried the following but it doesn’t seem to work:

=vlookup(B2, ‘worksheet2’!1:65536, ‘worksheet2’!5, FALSE)

Plus it doesn’t handle the multiple values for the same unique identifier issue.

Any help would be much appreciated!! Thanks!

 

[Oorang]

Hi,
Welcome to the board
I think you mean across tabs in the same workbook (Worksheets are the tabs.) You can do it this way:
=VLOOKUP("foo",Sheet4:Sheet1!A1:F10,6,0)

Bill actually did a podcast on it: http://mrexcel.libsyn.com/media/mrexcel/podcast974.mp4