=IFERROR(MATCH(E6,G6:G12,0)>0,FALSE)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Scruffy Huffy
Sent: Mar/Sat/2012 05:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ An EASY One: I Need a formula that checks if a
value is part of a list.
Perfect...Thanks much!
On Saturday, March 17, 2012 8:16:33 AM UTC-4, Rajan_Verma wrote:
>
> =IFERROR(MATCH(E6,G6:G12,0)>0,FALSE)
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Scruffy Huffy
> *Sent:* Mar/Sat/2012 05:29
> *To:* excel-macros@
What we have here is “a failure to look in the help index”
excel 101
=LOOKUP(E6,G5:G12)
=MATCH(E6,G5:G12)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Scruffy Huffy
Sent: Saturday, March 17, 2012 6:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
Don,
You would think...I don't like the onboard help, but I did Google it and
looked for sometime by myself. In retrospect, there's no "one function"
that works.
Neither the LOOKUP or the MATCH give the result I needed. Rajan's
adaptation is simple and does what I need. I just thought there