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.