On Monday, January 7, 2013 6:36:40 PM UTC-8, Steve wrote:
Hi,



I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index".



For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes".



Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank.



Thanks for any help...

Hi Steve,

Try this in E2 which will give you a "yes" for your "black" statement and by default a blank for the "brown" statement.

=IF(AND(C2="black",D2G2),"yes","")

Regards,
Howard