Consulting

Results 1 to 3 of 3

Thread: Solved: I need a "MATCH" help

  1. #1

    Solved: I need a "MATCH" help

    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

  2. #2
    VBAX Mentor
    Joined
    Jun 2004
    Posts
    363
    Location
    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))
    Last edited by mbarron; 03-05-2010 at 07:33 AM. Reason: Added Index Match formula

  3. #3
    THANKS SOOOOOOOOO MUCH
    They both worked Well
    REGARDS
    AYSAM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •