+ Reply to Thread
Results 1 to 12 of 12

Search in Table vlookup / Hlookup or INDEX - MATCH command

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Search in Table vlookup / Hlookup or INDEX - MATCH command

    Hi There

    I have a table which is attached I need to enter Aircraft registration , total crew number, and cockpit crew and then get

    MAX Take of weight
    Max Landing Weight
    Max ZFW
    DOW
    DOI

    I appreciate if some one tell What is the best formula that I can have? table attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    I don't know what the result should be.

    See the example.

    Please reply if this is what you're up to.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    Thanks for your reply

    I need to enter an aircraft registration like
    9M-XXE
    total crew 11
    cockpit crew 2

    then I get :
    Max Take off weight: 233,000
    Max Landing weight:187,000
    MAX ZFW weight: 175,000
    DOW for 11 crew : 123,134
    DOI, for 2 cockpit crew:99

    of if i enter another aircraft registration, total crew and cockpit crew get resepective result like list above

    thanl

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    see the attached file.

    please reply if this is what you're up to.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    Thanks a million for the great help it work perfectly O.K ...

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    Glad I could help. Thanks for the reply.

    If the question is solved, will you mark your question as solved?

    If you have (other) questions, on this item, just ask.

  7. #7
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    in other words I need to have this formulas in different cell in different sheets to find these values from the table
    and I can add up or deduct values from these figures... thank you again

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    Which question you have on this item?

    I don't understand.

    Notice my main language is not englisch.

  9. #9
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    please see see attached file and the error, need to fix them... thanks
    Attached Files Attached Files

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    See if this is what you up to.

    Also added an data validation (see the green cell).

    Also used a defined name to fill the data validation.

    Please reply if this is what you are up to.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    09-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    yes this is what i am exactly looking for, but whilst I am using the same formula in other sheets or change the cell
    it return #N/A

  12. #12
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,952

    Re: Search in Table vlookup / Hlookup or INDEX - MATCH command

    just show me, then i can help you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1