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.