Hi,

A1 is a list box with 12 options to pick from
B1 is a yes or no field
C1 needs to look at B1, if yes, look at A1, see the chosen option and go to
a separate worksheet to pull the corresponding cost. If no, then enter $0.00.

I've playing with this formula but not getting anywhere. Is it possible to
do this?
=IF(ISNA(VLOOKUP(GB3,RATES!$A$67:$B$78,2,FALSE))," ",VLOOKUP(GB3,RATES!$A$67:$B$79,2,FALSE))

Kathleen