Forum Discussion
VLookup or Equivalent
Hello, I am familiar with VLookup and it's basic functions, however I am looking for someone that could help with the follows. The attached is the basic premis for the spreadsheet, one sheet ...
As variant
=IFERROR(INDEX(Haulier!$A$1:$F$76,MATCH($E2,Haulier!$A$1:$A$76,0),MATCH($K2,Haulier!$A$1:$F$1,0)),"no such")
Please see in column O attached
Thank you for getting back to me.
This seems to be along the right lines, is there a way of doing as a range on the columns, rather than a specific cell, please.
- Actually on second glance, I can see what you have done and breakdown the formula.
Thank you for your help.AdamUKSaint , good, you are welcome
