Vlookup from multiple tables

  • Thread starter Thread starter Pinda
  • Start date Start date
P

Pinda

I have four tables in four different worksheets named A B
C D. They all have a ID number in column A. I've got
another global worksheet that combines the four tables
into one. Is there a way I can use vlookup to search in
multiple tables? I need to establish some sort of link so
anything that changes in the A B C or D will automatically
update the global worksheet.

Thanks in advance.

Pinda
 
I'm not sure I follow what you're trying to do with the global
combined tables, but this might give you one way:

Assume your lookup value is in A1 and your table/sheet name
designator (i.e., A, B, C or D) is in B1. Then:

=VLOOKUP(A1,INDIRECT("'"&B1&"'!A:B"),2,0)
 
Back
Top