=if(b1="no",0,vlookup(a1,rates!a:b,2,false))

This assumes that the value in A1 is either Yes or No (nothing else!).

You may want to add that =isna() stuff in case there's no match.

=IF(B1="no",0,IF(ISNA(VLOOKUP(A1,Rates!A:B,2,FALSE )),"",
VLOOKUP(A1,Rates!A:B,2,FALSE)))

Kathleen wrote:

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

--

Dave Peterson