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.
=VLOOKUP(F2,SizeCodeSizeSex,2,FALSE)
after moving the named range over to the right one column.
Bookmarks