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/Unit
Different 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

Report •


✔ Best Answer
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)))

MIKE

http://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))

MIKE

http://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/a

Do you mean the Excel Error code #N/A ?

MIKE

http://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
✔ Best Answer
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)))

MIKE

http://www.skeptic.com/


Report •

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

Report •


Ask Question