compare two text and if equal copy adjacent data
 

I want to compare two texts in different sheets and if equal copy adjacent
data. Please let me know how I can do it.

compare two text and if equal copy adjacent data
 

not sure if this is what you want but you can use the VLOOKUP function

type in the cell

= VLOOKUP(sheet1a1,sheet2a1:b100,2,0)

where sheet1a1 represents the reference cell on the first sheet and
sheet2a1:b100 represents the renge of cells on the second sheet

"Prashanthom" wrote:

I want to compare two texts in different sheets and if equal copy adjacent
data. Please let me know how I can do it.