Need help with if statement with text values from a range. A B

1 apple red

2 orange orange

3 banana yellow

4 grape purple

5

6 Fruit: grape

7 Color: FALSECell B6 formula Data validation-List =$A$1:$A$4

Cell B7 formula {=IF(B67=A1:A4,B1:B4)}It works when I select Apple in the dropdown list for Cell B6, but any other fruit selection won't work.

I think I'm missing something simple. Any help is appreciated.

Sorry,

updated original post for formula correction.

Cell B6 formula is a data validation list that is =$A$1:$A$4

And Cell B7 formula is {=IF(B6=A1:A4,B1:B4)}

Thanks

Ask Your Question

Weekly Poll