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 ...
Hi
Try INDEX and MATCH. You can use them both.
You can also plug your data-set into Power Pivot enabling DAX and use the RELATED function.
Hope that help
Thank you for getting back to me.
Please could you possibly provide an example? As I am struggling to match the Array against the lookup, for it to return a result.