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? |
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? |
All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com