Use a variable in a vlookup

[[email protected]]

Goo day, Gurus.

Using a vlookup formula to return a value from a separate workbook containing multiple sheets. I must reference the sheet in the formula in the 'table_array'. The sheet I must lookup from will change depending on the vendor number for that part. Lets say the in the same row as the 'lookup_value' I also have the vendor number, (010299,010314,011170,etc.), and my other book is split into worksheets based on the vendor number. I am looking up that part number for that vendor and pulling in the manufacturer. Here is the formula that works:

Please Login or Register  to view this content.

I want to change "010299" to be whatever value is showing in column V of that same row. I tried this, and a few similar variations, but they didn't work:

Please Login or Register  to view this content.

Thanks in advance for any help you can offer.

Have a good one.

[Jonmo1]

You need INDIRECT there..

=VLOOKUP(F2,INDIRECT("'[PM Vend (02-03-2015).xlsx]"&V2&"'!$B:$T"),19,FALSE)

[abousetta]

Try:

Please Login or Register  to view this content.

[[email protected]]

That did it, guys. Thanks.a million. I will mark this thread as "SOLVED".

Have a great day.

[[email protected]]

That did it, guys. Thanks.a million. I will mark this thread as "SOLVED".

Have a great day.

[abousetta]

Thanks for the confirmation.

Good luck.