thanks for your interest Max, but I'm looking for a different solution:

I wanna that the formula check in the page what's the PC position for the
AL14927021 but it have to check if "PC" is before "PER" and it should do the
same job for many LVSNR else.

If you can help me.
thank you.
--
BBB


"Max" wrote:

Taking your example:
for the AL14927021, I wanna know what's the PC position
the result is "X".

Assuming your source data in cols A to E,
and you want to flag it in an adj. col F based on the 2 conditions
then this formula in F2, copied down:
=IF(AND(A2="AL14927021",E2="PC"),"X","")
will do it

Mark this response, press the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"AND" wrote:
thanks for your support Max.
I have already thought to that way, but the data I'm going to check are
thousands: I need of that formula to analize hundreds of data.