| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup a value in column B but return value in Column A
Hi!
I am wondering if there is any way we can vlookup a certain value in column B but return value in Column A. Thank you very much! Ken |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup a value in column B but return value in Column A
Hello Ken,
You can't do that with VLOOKUP but you can use an INDEX/MATCH type formula, e.g. to lookup C1 in column B and return the corresponding value from column A =INDEX(A:A,MATCH(C1,B:B,0)) "Ken" wrote: Hi! I am wondering if there is any way we can vlookup a certain value in column B but return value in Column A. Thank you very much! Ken |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup a value in column B but return value in Column A
Try this:
=INDEX(B1:B10,MATCH(lookup_value,A1:A10,0)) -- Biff Microsoft Excel MVP "Ken" wrote in message ... Hi! I am wondering if there is any way we can vlookup a certain value in column B but return value in Column A. Thank you very much! Ken |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup a value in column B but return value in Column A
Ooops!
I have the ranges backward! =INDEX(B1:B10,MATCH(lookup_value,A1:A10,0)) Should be: =INDEX(A1:A10,MATCH(lookup_value,B1:B10,0)) -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this: =INDEX(B1:B10,MATCH(lookup_value,A1:A10,0)) -- Biff Microsoft Excel MVP "Ken" wrote in message ... Hi! I am wondering if there is any way we can vlookup a certain value in column B but return value in Column A. Thank you very much! Ken |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup a value in column B but return value in Column A
Hello! Daddy Long Legs,
Thank you very much! It works well. Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup column return issue | Excel Discussion (Misc queries) | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
| Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
| Search one column and return value from next column | Excel Discussion (Misc queries) | |||
Linear Mode
