Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look up a value in one colum and insert the value found in the adj
I use vlookup when entering data in a row to find a matching item in a two
column table and replace the entered data with the suggested item. No problem with this. I then want to pick-up the data in the adjacent column of the table and place that data in a column in the same row where I am entering data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert new colum, without changing information | Excel Worksheet Functions | |||
colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Search for a test string and if found insert 'x' in clumn 'A' | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) |