Find and replace with information from another workbook.

[SHANEBRUNER]

OK,
I need to find a value in a column and replace it with a corresponding value in anther workbook.
so if the value in the first column in the first workbook is x i need it to look in the second workbook for x and return what is in column 2 in the same row? Perhaps i need to use a vlookup?

 

[g4cox]

Hi try

=VLOOKUP(“first cell in the first col in the first wb”,”second wb first to second col”,2,FALSE)

Then you can just copy paste special.[FONT=&quot]<o></o>[/FONT]