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
---
"S.elhalaby" wrote:
i need to lookup a value in a specifc range of data, in the same order of the
try and catch process.