Please see attached spreadsheet. I'm getting N/A results on my Vlookup functions. Same concept in 3 places, and same error. In my VLookup, I'm asking for results from column 1 of the lookup tables referenced. Formula's the same, but different references. Can somone figure out my error? I'm wanting the code that matches the item in each case. Thanks.
Hi HarvardMagesty,
The range of you Vlookups needs to be the leftmost column of the range it is looking in. On your Transactions Tab you are looking for Boys 3mos in a range named SizeCodeSizeSex. The leftmost column of that named range are numbers so you get a #N/A as it can't find "Boys 3mos". Redefind the range to columns C and D and then make the return number 2 and I think you'll get what you want.
In G2 should be.
after moving the named range over to the right one column.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
BINGO! Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks