# Solved IF and VLOOKUP Formula Help

July 7, 2011 at 11:59:10
Specs: Windows XP
 I am working on a costing spreadsheet and would like to use a formula to come up with the correct cost depending on a couple of variables.Column G = Price/UnitDifferent Sheet = Cost Conversions (VLOOKUP(A2,'Cost Conversions'!A:J,9,0)So, I want the formula to take the price from column G if it is less than \$10.00. If it is more than \$10.00, then I want the formula to take the price from the vlookup. Is this possible?Thanks,Heather

See More: IF and VLOOKUP Formula Help

July 7, 2011 at 16:07:20
 It would look something like:=IF(XX1<=10,G?,IF(ISNA(VLOOKUP(A2,'Cost Conversions'!A:J,9,0)),G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0)))MIKEhttp://www.skeptic.com/

#1
July 7, 2011 at 12:13:49
 With only the supplied info, the best I can offer is somthing along the lines of:=IF(XX1<=10,G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0))MIKEhttp://www.skeptic.com/

Report •

#2
July 7, 2011 at 13:18:57
 Ok. Thanks. Is it also possible to add an if n/a clause to this? For example, if the final cost comes out to n/a, can it take the cost from column G?

Report •

#3
July 7, 2011 at 14:30:58
 if the final cost comes out to n/aDo you mean the Excel Error code #N/A ?MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
July 7, 2011 at 14:47:20
 Yes, the error code #N/A.

Report •

#5
July 7, 2011 at 16:07:20
 It would look something like:=IF(XX1<=10,G?,IF(ISNA(VLOOKUP(A2,'Cost Conversions'!A:J,9,0)),G?,VLOOKUP(A2,'Cost Conversions'!A:J,9,0)))MIKEhttp://www.skeptic.com/

Report •

#6
July 8, 2011 at 08:02:00
 Great. Thank you so much for your help.

Report •