Forum Discussion
Multiple V-LookUp returns
Hi,
In column A of workbook 1 I have a number of customer ref codes. I want to do a v-lookup of these codes into workbook 2 to return the orders associated with these codes (located in column D...
Hi Kevin,
Thank you for your reply however I'm still having a bit of difficulty with it.
The first [External Workbook.xlsx] - is that the book I'm using or the book I want to retrieve the information from? and vice versa for the second book?
When I try the formula I get the error message #NAME?
Also why is it Sheet 2?
Sorry for all the questions,
Andrew
Hi Andrew,
What version of Excel are you using? TEXTJOIN function is a new function and maybe it doesn't exist in the version that you are using.
Sorry for such a late response.
Regards,
Kevin