compare two text and if equal copy adjacent data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to compare two texts in different sheets and if equal copy adjacent
data. Please let me know how I can do it.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formulas - comparing adjacent cells 5
EXACT function vs. equals operator 11
Comparing 3 columns? 5
Formulas That Reference ADJACENT Sheet 4
Comparing two spreadsheets 2
Compare 2 rows of text and return adj value 6
Alt codes 4
Excel Move or Copy Stopped Working? 0

Back
Top