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:
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.Please Login or Register to view this content.
Have a good one.
Bookmarks