Imported data, cell looks blank but is not??

[cvansickle]

Hello all, and thanks in advance...

I have a small excel sheet that I am importing from Microsoft access..

There are 10 feild that show the last amount someone paid. What I want to do is find which cell that is.. (If there were only 2 payments the 2 fields would have data and the other 8 blank)

My formula is:

=IF(AN2>0,10,IF(AM2>0,9,IF(AL2>0,8,IF(AK2>0,7,IF(AJ2>0,6,IF(AI2>0,5,IF(AH2>0,4,IF(AG2>0,3,IF(AF2>0,2,IF(AE2>0,1,0))))))))))

The problem I am having is, that although the cell looks empty, there must me something in there that is showing a vaule. I even tried a ISBLANK() but it comes back false.

Any ideas on how I skip over that cell unless there is a true vaule?

Thanks again..

 

[Gerald Higgins]

Not tested, but I think something like this should work

=INDEX(A1:J1,MATCH(HLOOKUP("zzz",A1:J1,1,TRUE),A1:J1,0))