You read my mind Simon!

That's exactly what I did!

Sometimes I forget KISS.(Keep It Simple Stupid!)

"SimonCC" wrote:

After looking through all of the posts, I think I understand what you're
trying to do. You shoud probably do this in two steps.

First, use an evaluation column (column D if currently not used) in Sheet2
to show values of 1, 2, 3, 4, 5:
=IF(Sheet2!AA2="X",1,IF(Sheet2!AB2="X",4,IF(Sheet2 !AC2="X",2,IF(Sheet2!AD2="X",5,IF(Sheet2!$AE$2="X" ,3,"")))))

Then in Sheet1:
=IF(ISNA(VLOOKUP(B1069,Sheet2!$C$2:$D$19634,2,FALS E)),"",VLOOKUP(B1069,Sheet2!$C$2:$D$19634,2,FALSE) )

If you end up using a different column in Sheet2 as evaluation column, your
VLOOKUP range and return column would need to be adjusted as well.

-Simon

"wnfisba" wrote:

Can anyone tell me what's wrong with this formula???

It doesn't seem to like the
(IF(Sheet2!$Z2='X','1',
portion of the formula and is highlighting the 'X'...

PLEASE HELP! I'm desperate...

Here's the whole formula...

=IF(VLOOKUP(A2,Sheet2!$B$2:$B$19634,(IF(Sheet2!$Z2 ='X','1',IF(Sheet2!$AA2='X','4',IF(Sheet2!$AB2='X' ,'2',IF(Sheet2!$AC2='X','5',IF(Sheet2!$AD2='X','3' ,''))))))))