compare two text and if equal copy adjacent data

P

Prashanthom

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

max power

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
 
Top