Hi,
I am trying to use table references in a vlookup but I get #REF! errors. I have two tables ("FruitTable" and "BuyerTable") and I want to lookup the heading in the BuyerTable from within the column of the FruitTable and return a value from the third column in the FruitTable. This is my formula:
Please see attachment for details. Any help gratefully appreciated.Please Login or Register to view this content.
Bookmarks