Lookup Last Column with Text Value

[magic_ma]

Hi

I need to lookup the latest supplier in the attached worksheet, and i already insert the lookup value formulae but i didn't work in certain column.

Look at column k2 it suppose return 0 answer but i show blank
and colum k3 it suppose return chinese word which is 深圳市帝国科技有限公司 (Chinese character)
column k4 is the correct answer
but come to k5 the answer should be ABC

WHAT HAPPEN? i done a lot of formulae it still didnt work.

Please.... Some one solve it out for me.

[Punnam]

Check the data in column J " ' ", you will find this symbol if you delete " ' ",
Then every thing is working fine

Punnam

[:) Sixthsense :)]

Try this...


In K2 Cell


=LOOKUP(2,1/(TRIM(A2:J2)<>""),A2:J2)

Drag it down...

Because the cells seems to be blank is not really blank

[magic_ma]

Thanks and its well done now.