On Apr 11, 9:54*am, Mike H wrote:
Hi,

Use index(match for a left lookup

=INDEX(A2:A14,MATCH(E2,C2:C14))

You index A2 to A14 i.e. the column to return the value from then
you match a value E2 in C2:C14 and the value indexed in Column A is returned.

Mike



"K" wrote:
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- Hide quoted text -

- Show quoted text -

Thanks Mike