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.
try and catch process.
M
Max
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
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
F
Fred Smith
The lookup function in Excel is Vlookup. Help will tell you all about it.
Regards,
Fred.
Regards,
Fred.
H
Heinz Guderian
.... 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.
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.