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.