Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data
I have a column that has data A the next column has the data A = data B
When I enter the data from column A I want the data that A = to, to automatically populate in the next column is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data
Try this:
...........A..........B 1........X........XB 2........Y........YB 3........Z.........ZB D1 = Y =VLOOKUP(D1,A1:B3,2,0) Result: YB Biff "yaheegunsome" wrote in message ... I have a column that has data A the next column has the data A = data B When I enter the data from column A I want the data that A = to, to automatically populate in the next column is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
Pulling data | Excel Worksheet Functions | |||
Pulling Data from Another Worksheet | Excel Discussion (Misc queries) | |||
pulling data! | Excel Worksheet Functions | |||
Pulling data from web | Excel Discussion (Misc queries) |