Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I look up a value from a table and return data for other column
I have a table with 2 columns of data as shown in sample
below. Col-A Col-B Apple A Pear P Orange O In a Cell say D1, I used "Data" - "Validation" to create a dropdown box (combo box) by sellected Col-A as list which allow me to select from Col-A. However, what function I can use at the same to also return to me the corresponding value in column-B instead of the selecte item ? E.g Select Pear, the function returns to me letter P. Any assistance is greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I look up a value from a table and return data for other column
Application.Vlookup
use the excel worksheet function Vlookup (in VBA). -- Regards, Tom Ogilvy "Wellie" wrote in message ... I have a table with 2 columns of data as shown in sample below. Col-A Col-B Apple A Pear P Orange O In a Cell say D1, I used "Data" - "Validation" to create a dropdown box (combo box) by sellected Col-A as list which allow me to select from Col-A. However, what function I can use at the same to also return to me the corresponding value in column-B instead of the selecte item ? E.g Select Pear, the function returns to me letter P. Any assistance is greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP value in a table and return value in first column of same r | Excel Worksheet Functions | |||
Find values in table and return row/column name | Excel Worksheet Functions | |||
Find a value in a table and return the cell or column reference | Excel Discussion (Misc queries) | |||
Return a value from a table using Column and row names as input? | Excel Discussion (Misc queries) | |||
Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) |