PDA

View Full Version : Solved: I need a "MATCH" help



aysam
03-05-2010, 05:27 AM
PEACE to you all
I need a formula to match a number to another number in a serious of numbers.
more details in the attached file
any help 'd be greately appreciated

mbarron
03-05-2010, 07:30 AM
Does this formula give you the result you are expecting? Entered into I9 and copied down.
=VLOOKUP(H9,$C$9:$E$18,3,1)+H9-VLOOKUP(H9,$C$9:$C$18,1,1)

or if want to use the Index Match combo:
=INDEX($E$9:$E$18,MATCH(H9,$C$9:$C$18,1))+H9-INDEX($C$9:$C$18,MATCH(H9,$C$9:$C$18,1))

aysam
03-05-2010, 08:57 AM
THANKS SOOOOOOOOO MUCH
They both worked Well
REGARDS
AYSAM