I hit a roadblock figuring out this vlookup formula. It's not returning anything but the formula appears correct.
=VLOOKUP(H2, $A$2:$D$5, 4, FALSE)
I'm looking for the value in H2, selected the range, and column that I want to return, and looking for an exact match but when I hit enter, the formula doesn't respond.
Any insight or tips would be greatly appreciated. I'm attaching a sample excel file of what I'm trying to do.
thanks for your help!