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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Look up a value in one colum and insert the value found in the adj
It the data is somewhere to the right of the column
in the table that you found a match in that is part of VLOOKUP. http://www.mvps.org/dmcritchie/excel/vlookup.htm If the value is the left, you could rearrange your table; otherwise, use INDEX / MATCH see example for residence at http://www.mvps.org/dmcritchie/excel....htm#residence -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "lgr021238" wrote in message ... 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. |
Reply |
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) |