How test if a value is present in a list of values...?! This is driving me NUTS!

  • Thread starter Shiperton Henethe
  • Start date
S

Shiperton Henethe

msOutlook 2002 (SP2)


Hi

This is driving me NUTS!

How do I lookup a value to see if
it is within a column of values?

I have been tried the LOOKUP() function
but I cant get it to give a clean YES or NO.

Then I tried the IF() function using
a *range*. I tried something like:

=IF(G2=MyData!A2:A20,"YES","NO")

But that only seems to compare G2 with
the first one in the serious in this case
MyDate!A2...

Any other suggestions?

CAN IT BE THIS HARD?!


Ship
Shiperton Henethe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get Outlook2003 signature to default to same colour & font as the email I'm writing? 0
How can I find out which folder an email is in? 2
How can set up a rule to I move emails from contacts in a given category... into a particular email 3
how do i remove microsoft outlook it is driving me nuts 1
Change Row of text to values 5
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4) 6
How do I search for a string, without risking the "#value!" error? 5
Creating Chart Dynamically (It is Driving Me Nuts) 2

Top