Forum Discussion
Solved
VLOOKUP returning #N/A when using text
Hi there, Please see attached a copy of the workbook I'm building, or see this link: https://1drv.ms/x/c/e0c0b13a875a27d1/ERdu4SadbW5EkYvStiVi9gsB5xyxB5menKJAP0Wq6rtajQ The idea is when I typ...
VLOOKUP works from left to right, i.e. lookups the value in left most column and if returns the value in matched row from the column in next parameter.
In your case works, for example, INDEX/MATCH
=IFNA( INDEX( INDEX( AllCards, 0, MATCH(TestDeckMain[[#Headers],[ATTRIBUTE]], AllCards[#Headers], 0) ), MATCH(TestDeckMain[@[NAME]:[NAME]], AllCards[[NAME]:[NAME]], 0 ) ), "" )Please check in attached.
You have to allow others to view the workbook - I now get "Sorry, an error has occurred".
Strange, it said anyone with the link can edit. I've added an attachment HansVogelaar