| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO VLOOKUP BACKWORDS
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO VLOOKUP BACKWORDS
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO VLOOKUP BACKWORDS
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO VLOOKUP BACKWORDS
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO VLOOKUP BACKWORDS
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--- -- RyGuy "K" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
