HOW TO VLOOKUP BACKWORDS

[K]

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

 

[K]

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

 

[Mike H]

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]

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







- Show quoted text -

Thanks Mike

 

[ryguy7272]

This is a good resource for your future needs:
http://www.contextures.com/xlFunctions03.html
http://www.contextures.com/xlFunctions02.html

See this too:
http://www.mrexcel.com/tip021.shtml


Regards,
Ryan---