Forum Discussion
VLOOKUP returning #N/A when using text
Hi there,
Please see attached a copy of the workbook I'm building, or see this link: Test - My Yugioh Cards.xlsx
The idea is when I type a card's name in the "NAME" column in table "TestDeckMain" in sheet "Test Deck", the rest of the row should auto-populate by pulling information from table "AllCards" in sheet "All Cards".
I think it's a format problem of some sort, but from looking up articles and posts I haven't been able to work it out. I'm hoping someone could take a quick look and see if I'm missing something, I'd be very grateful. I'm mostly self-taught, so apologies if there is any poor design ha ha
I've already entered a few different card names with various characters to test different scenarios in case this helps.
Many thanks,
Etienne
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
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.
