| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup from left to right.
Hi Guys Me again :D
Question, is there a way to get a =VLookup to lookup a value from Say B and return the Value from A? I got a report that generates all the time but the order of the report puts the lookup value in the middle of the DATA i need. so i want to do a lookup in a table of A:F on any Column within there and lookup the value from a different location. Say lookup Value From B and return A like i say. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup from left to right.
Vlookup only works from left-to-right. Use Index/Match:
=INDEX(A:A,MATCH(C1,B:B,0)) Biff "Gareth - Network analyst." wrote in message ... Hi Guys Me again :D Question, is there a way to get a =VLookup to lookup a value from Say B and return the Value from A? I got a report that generates all the time but the order of the report puts the lookup value in the middle of the DATA i need. so i want to do a lookup in a table of A:F on any Column within there and lookup the value from a different location. Say lookup Value From B and return A like i say. Can this be done? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup from left to right.
I didnt even think of doing that hahaha, Thanks alot for the assist Valko :D
"T. Valko" wrote: Vlookup only works from left-to-right. Use Index/Match: =INDEX(A:A,MATCH(C1,B:B,0)) Biff "Gareth - Network analyst." wrote in message ... Hi Guys Me again :D Question, is there a way to get a =VLookup to lookup a value from Say B and return the Value from A? I got a report that generates all the time but the order of the report puts the lookup value in the middle of the DATA i need. so i want to do a lookup in a table of A:F on any Column within there and lookup the value from a different location. Say lookup Value From B and return A like i say. Can this be done? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup from left to right.
You're welcome!
Biff "Gareth - Network analyst." wrote in message ... I didnt even think of doing that hahaha, Thanks alot for the assist Valko :D "T. Valko" wrote: Vlookup only works from left-to-right. Use Index/Match: =INDEX(A:A,MATCH(C1,B:B,0)) Biff "Gareth - Network analyst." wrote in message ... Hi Guys Me again :D Question, is there a way to get a =VLookup to lookup a value from Say B and return the Value from A? I got a report that generates all the time but the order of the report puts the lookup value in the middle of the DATA i need. so i want to do a lookup in a table of A:F on any Column within there and lookup the value from a different location. Say lookup Value From B and return A like i say. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use 2nd digit from the left in cell contents for vlookup | Excel Worksheet Functions | |||
| Column labels run right to left, not left to right | Excel Discussion (Misc queries) | |||
| Vlookup and left function | Excel Discussion (Misc queries) | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| Can Vlookup check a cell to the left? | Excel Worksheet Functions | |||
Linear Mode
