Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel help! (V look up and a IF which are a logical and a reference.)

  1. Feb 20, 2010 #1
    Hi, Wondering if anyone can help me with figuring out of if it's possible to make a function on excel with V lookup and IF, if you can pls post an example.

    Or give an example of using both of these functions in a algorithm to reference to cells on another page in excel within the function.

    Thanks alot!
  2. jcsd
  3. Mar 7, 2010 #2

    Hmm. Not sure what you need the IF for. But you're welcome to look at my spreadsheet for Maplestory. It has a nice VLOOKUP centered database. You would just wrap the IF around the VLOOKUP. It's an Excel 2007 file. Look at the part labeled "Reference Lookup" in particular (rows 25, 26, and 27).


    EDIT: You could make an if statement anyway you wanted... for example: =IF(B2>=3, VLOOKUP(#1), VLOOKUP(#2)) or =IF(B2< VLOOKUP(#1), 6, VLOOKUP(#2))
    Last edited: Mar 8, 2010
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook