Results 1 to 3 of 3

Thread: Help with VLookup

  1. #1

    Help with VLookup



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there, I am trying to model a game system on excel to help my team. In the attached workbook on sheet 3, I have altitude and their corresponding temperatures. On B1 and B2, I have Types of Weather and Time of day respectively. On the right I have a table with Type of Weather and the decrease in temperature in Day and Night, on the listed weather type. I want to be able to select, the Types of weather from B1 and Time of Day from B2 and decrease/increase the temperature according to the table on the right.

    I tried using, IF(AND) statements to make this work, but i got an error, stating "too many arguments". I wonder if, I could use Vlookup for this, but i am not really sure how it will work with vlookup. Is there anyway I can make this work?
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =-20+INDEX($I$13:$J$20,MATCH($B$1,$H$13:$H$20,0),MATCH($B$2,$I$12:$J$12,0))

    then in next cell

    =B7-1

    copied down (to subtract a degree)


  3. #3
    Quote Originally Posted by NBVC View Post
    Try:

    =-20+INDEX($I$13:$J$20,MATCH($B$1,$H$13:$H$20,0),MATCH($B$2,$I$12:$J$12,0))

    then in next cell

    =B7-1

    copied down (to subtract a degree)
    thnx, that helps

Posting Permissions

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