VLOOK ups accross Multiple Tabs

[Kyaba]

Hi I am a newbie to the forum 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!

 

[Shane Devenshire]

Hi,

Your question refers to multiple tabs but your formula is only for worksheet2?

1. You can't use a single VLOOKUP to pull data from multiple tabs.
2. You can't use a standard VLOOKUP to return multiple results in general.
3. It is probably a bad idea to use a referece like 1:65536. The
references the entire worksheet which tends to slow VLOOKUP down.
4. It is not at all clear what your 3rd argument means - worksheet2!5 ?

What kind of results could be returned based on your data and how would you
want them returned? If there were two results would you want them added
together (numerical results) or concatenated in one cell or in multiple cells?