Compare 2 datatble and update the very first matching value

Help Studio
,
4

Hi @yashashwini2322

Try this

The image shows an Excel automation process that involves writing a VLOOKUP formula to cell B2 in Sheet1 and then auto-filling it. (Captioned by AI)
The image shows an Excel automation process that involves writing a VLOOKUP formula to cell B2 in Sheet1 and then auto-filling it. (Captioned by AI)585×857 24.9 KB

"=VLOOKUP(A2,Sheet2!A:B,2,0)"

Input:(Sheet1)

An Excel spreadsheet with headers "Column1" and "Column2" contains five rows of text data only in Column1. (Captioned by AI)
An Excel spreadsheet with headers "Column1" and "Column2" contains five rows of text data only in Column1. (Captioned by AI)544×421 5.01 KB

Input:(Sheet2)

A spreadsheet with two columns labeled "Column1" and "Column2" containing a list of text entries and corresponding numerical values, respectively. (Captioned by AI)
A spreadsheet with two columns labeled "Column1" and "Column2" containing a list of text entries and corresponding numerical values, respectively. (Captioned by AI)499×447 5.57 KB

Output:(Sheet1)

A spreadsheet with two columns labeled "Column1" and "Column2" contains five rows of data. (Captioned by AI)
A spreadsheet with two columns labeled "Column1" and "Column2" contains five rows of data. (Captioned by AI)595×565 7.1 KB

Regards,