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

  • Thread starter Thread starter Sirsh
  • Start date Start date
  • Tags Tags
    Excel Reference
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
Sign up Log in
1 reply · 3K views
Sirsh
Messages
262
Reaction score
10
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 a lot!
 

Discussion

Physics news on Phys.org
Sirsh said:
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 a lot!
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).

http://www.filefront.com/15772455/Maplestory.xlsx

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: