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.
Strange, it said anyone with the link can edit. I've added an attachment HansVogelaar
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.
- This is great, thanks! It took me a while to read into INDEX and MATCH, but I can see how versatile those functions can be 🙂
Karateka95 , you are welcome