Match values and update a specific value in a string

[gmoorthy]

I have 2 speradsheet ( A and B)

In spreadsheet A i have 2 columns
ColumnA ColumnB

Name1 YYYYMMDD
Name2 YYYYMMDD
Name3 YYYYMMDD


In spreadsheet b I have 2 columns
ColumnA ColumnB

Name1 </XML/jobdate=YYYYMMDD
Name2 </XML/jobdate=YYYYMMDD

I need to find a match for Names and then in spreadsheet B column B i need to replace the YYYYMMDDD with the YYYYMMDDD from Column B of spreadsheet A

 

[SkipVought]

Hi,

What have you tried so far?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}