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 doesnt seem to work:

=vlookup(B2, €˜worksheet2!1:65536, €˜worksheet2!5, FALSE)

Plus it doesnt handle the multiple values for the same unique identifier
issue.

Any help would be much appreciated!! Thanks!