Excel If statement w/ text values from range

Excel Excel 2007
August 12, 2010 at 11:34:11
Specs: Windows XP
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: FALSE

Cell 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.


See More: Excel If statement w/ text values from range

Report •


#1
August 12, 2010 at 11:39:33
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

Report •
Related Solutions


Ask Question