I've tried a couple different way to get this vlookup to work and I can't seem to get it. Essentially want I need to do is lookup the values in c2:k2 with the table aray on sheet 1, then return the first column of number in sheet one if it matches the range of lookup values.
I have attached what i'm looking at, if anyone can help, i would greatly appreciate it.
Thanks,
TJ
Bookmarks