On Apr 11, 9:12*am, K wrote:
200702 * * *146188 * * * * C33 * * * * * * * * * * *C33
200703 * * *146306 * * * * D55 * * * * * * * * * * *S45
200704 * * *146392 * * * * S45
200705 * * *146504 * * * * TT5
200706 * * *146614 * * * * GG3
200707 * * *146709 * * * * VXT
200708 * * *146834 * * * * ZSD
200709 * * *146911 * * * * SDF
200709 * * *146910 * * * * ERW
200710 * * *147093 * * * * SE8
200710 * * *147095 * * * * SSS
200710 * * *147013 * * * * KLO
200711 * * *147096 * * * * GST

I want vlookup or similar formula in column "F" which should lookup
value of column "E" in columns "A , B & C" and bring value from column
"A". *I know that normaly vlookup formula always bring value from the
next column but I want vlookup formula which should bring value from
back or privous column from the match value column
I want something "=VLOOKUP(E2,A2:C13,-2,0)" . If you notice in my
formula I put "-2" instead of "2". I know it not work like this but I
need some formula to work like this. I hope you understand what I am
trying to say. Please if anybody know this sort of formula. Thanks

sorry I forgot to mention columns on top of data (please see data
below)

A B C D
E F -----------Columns
200702 * * *146188 * * * * C33 * * * * * * * * * * *C33
200703 * * *146306 * * * * D55 * * * * * * * * * * *S45
200704 * * *146392 * * * * S45
200705 * * *146504 * * * * TT5
200706 * * *146614 * * * * GG3
200707 * * *146709 * * * * VXT
200708 * * *146834 * * * * ZSD
200709 * * *146911 * * * * SDF
200709 * * *146910 * * * * ERW
200710 * * *147093 * * * * SE8
200710 * * *147095 * * * * SSS
200710 * * *147013 * * * * KLO
200711 * * *147096 * * * * GST