IF Help

  • Thread starter Thread starter raspywench
  • Start date Start date
R

raspywench

I am trying to find the right formula for the following:

If Name in Column A on Sheet 1 matches the Name in Column A on Sheet 2,
I want the adjacent results from Column B on Sheet 2 to show in Column B
on Sheet 1.

The name columns do not necessarily have the same information in them.

Any help would be appreciated!

Thanks!
 
Hi,

Use Vlookup formula. For eg. if your range in Sheet 2 is from A1 to B100
and you want the data in column B of Sheet 2 to appear once the name
column in sheet 1 and sheet 2 are matched, use

=VLOOKUP(A1,Sheet2!A1:B100,2,FALSE)

Govind.
 
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

Need VLOOKUP to Work Two Ways 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
VLOOKUP and IF together 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Need help with ISNA, INDEX, MATCH 2
Help needed 0
Creating a dynamic IF statement 2
Match value return a text 6

Back
Top