Lookup Function Not in Ascending Order
Precisely what I was looking for. Thank you so much! I am extremely happy
now; No more repetitive data entry!
But regardless, on your INDEX/MATCH question, change the INDEX range
to the whole range and put in a column reference. So this checks
column E, then returns an answer from column H, which is the 4th
column of the range:
=INDEX(E:H,MATCH(E10,E:E,0),4)
|