VLOOKUP returning #N/A when using text
Hi there,
Please see a copy of the workbook I’m building: 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
Hi there, Please see a copy of the workbook I’m building: 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 Read More