I need to use a vlookup to find some information in another workbook where the worksheet will be a variable, which I would like to get from a cell reference.
The sheets will be suppliers names, so for example:
Sheet1: supplier_1 Sheet2: supplier_2
The Vlookup will look something like this:
=VLOOKUP(A2,'[Suppliers List]B2'!$A:$C,3, False)
Column A will be a list of product ID's and column B will be the suppliers name, so in the example above B2 would equal supplier_1.
Is it possible to put the reference into the formula directly in excel or would I need to use VBA?