Hello,
I've attached an excel file with the format and info on how the formula should work.
Any help would be greatly appreciated.
Hello,
I've attached an excel file with the format and info on how the formula should work.
Any help would be greatly appreciated.
you can solve with simple IF formula, see attached
Even simpler, invert the second table and use
=INDEX($H$4:$H$8,MATCH(C4,$F$4:$F$8,1))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber