MrExcel Publishing
Your One Stop for Excel Tips & Solutions

refer to column


Posted by joseph on March 05, 2001 3:24 PM

I want to refer to an entire column using the "IF" function. For example, I want to enter a formula that searches an entire column for a value and displays "true" if the value is anywhere in the entire column. Can this be done using the if function


Posted by David Hawley on March 05, 2001 4:18 PM

Hi Joseph

You would use a Lookup function for this like below:

=LOOKUP("dog",A:A)>1


This will return "True" if the word "dog" is in Column A

Dave

OzGrid Business Applications

Posted by David Hawley on March 05, 2001 4:19 PM

Oops, should be =LOOKUP("dog",A:A)>0

OzGrid Business Applications