how to lookup if value exists in a range of data?

  • Thread starter Thread starter S.elhalaby
  • Start date Start date
S

S.elhalaby

i need to lookup a value in a specifc range of data, in the same order of the
try and catch process.
 
You should illustrate clearly what you mean
with sample data, calc logic and expected results

Anyway, here's one venture hazarded ..
Something like this in B1: =IF(COUNTIF(Z:Z,A1),"Yes","")
will check whether the value in A1 exists anywhere within col Z
Copy B1 down to return correspondingly for other values in A2 down

If above provides an iota of help, click the YES below. Clicking YES will
not dissuade other responders from plunging in with their offers for you.
From my experience.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
 
The lookup function in Excel is Vlookup. Help will tell you all about it.

Regards,
Fred.
 
.... there are two points I want to make here:

1. This will not exactly work for the case specified by the original poster. If the value is within the boundary of the range, the result will be closest approximation. Of course if you have an exact match, then there is nothing like it.

2. What about hlookup? :)

The solution using countif works best in this case.
 
Back
Top