Doing Vlookup and IF statements in excel 2007
October 15, 2008
IF statements
If(or(c=20, c=30), b2 *1.05, b*1.02)
Example of an OR statement. We can do “AND”, by replacing the OR.
Or statement includes the following:
Condition, value if true, value if false.
Vlookup value
=vlookup ( Look up value, look up range, col num, true or false)
If true, it isn’t exact; false is exact.
Colum num is what you want to return.
If you enjoyed this post, make sure you subscribe to my RSS feed!
Posted in Excel
content rss
June 12th, 2009 at 4:44 pm
How do you write a forumula with VLOOKUP in the IF statement
I have three conditions, each one has a different VLOOKUP chart:
Concert, Sport, Family (in column E of sheet)
If it is Concert, it should VLOOKUP A5:C10
If it is Sport, it should VLOOKUP A14:C23
If it is Family, it should VLOOKUP A27:C37
I am currently sorting my data and entering my invidiual VLOOKUP formulas into the cell, however I want to write one forumla that I can enter into all the cells
My VLOOKUP formula for concerts that is currently working is
=VLOOKUP(L551, VLOOKUP!A$5:C$10,3)
My VLOOKUP formula for sport that is currently working is
=VLOOKUP(L551, VLOOKUP!A$14:C$23,3)
My VLOOKUP formula for family that is currently working is
=VLOOKUP(L551, VLOOKUP!A$27:C$37,3)
**(column L is the value to lookup in table, VLOOKUP! is refering to another sheet)
I wrote an IF statement that worked with “A” “B” “C” as [value if true], but when I put my VLOOKUP forumlas into it, it no longer works
=IF(E551=”Concert”, “A”, IF(E551=”Sport”, “B”, “IF(E551=”Family”, “C”, “ERROR”)))
If I edit the equation to include the VLOOKUP, it no longer works:
=IF(E551=”Concert”, “=VLOOKUP(L551, VLOOKUP!A$5:C$10,3)”, IF(E551=”Sport”, “=VLOOKUP(L551, VLOOKUP!A$14:C$23,3)”, “IF(E551=”Family”, “=VLOOKUP(L551, VLOOKUP!A$27:C$37,3)”, “ERROR”)))
June 20th, 2009 at 10:28 am
Sorry, I don’t really know, since I haven’t touched that in months now. Try yahoo answers.
March 23rd, 2010 at 9:14 am
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to lookup 2 different dates and if both of those dates appear on one sheet, I need the associated value to be returned. If this is possible, how would I do this?
September 26th, 2011 at 3:40 pm
Use IF(ISERROR(VLOOKUP,THRUE_VALUE,FALSE_VALUE)