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.

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.