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?