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

[Sirsh]

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!

 

[Wetmelon]

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))