Compare multiple columns in multiple sheets excel

Question

I am a complete novice when it comes to excel. I have a workbook that has 2 similar worksheets. Worksheet 1 is my master worksheet had more data. Both worksheets has 2 columns, Request No and Time.

Worksheet 1
Request No.   |   Time
1234          |   27
7890          |   67

Worksheet 2
Request No.   |   Time
1234          |   27
7890          |   60

I want to compare worksheet 1 Request no. with worksheet 2 request no. and time column against each request no.

Thanks in advance

EDIT : I want to display the result in last column if it matches or not? enter image description here

Hello Tim, I have added the image, I have changed the variables and range in VlookUp formula, but it doesn't work?

I want to display the result in last column if it matches or not? — Rahul Gupta
– Rahul Gupta, Commented Jul 3, 2015 at 7:24

Tim Biegeleisen · Accepted Answer · 2015-07-03 07:42:35Z

2

The VLOOKUP function should do the trick. Here is a screen capture showing you how you can do this:

enter image description here

Enter the following formula into C2:

=IF(VLOOKUP(A2, Sheet2!A2:B3, 2) = B2, "yes", "no")

This assumes that your second worksheet contains the same layout as the screen capture for the first worksheet which I have above. You may also have to adjust the range of the VLOOKUP if you more than 2 rows in your actual data set.

answered Jul 3, 2015 at 7:42

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rahul Gupta Over a year ago

Thanks Tim, I have added the image, I have changed the variables and range in VlookUp formula, but it doesn't work. Any advise?

Hamelraj · Accepted Answer · 2015-07-03 07:28:45Z

0

here is a code for just try and check chek when you use diffrent sheets u want remember this To reference a cell of a different Workbook use this pattern:

[<Workbook_name>]<Sheetname>!<Cell>

example : [Worksheet 1]sheet1!A1

answered Jul 3, 2015 at 7:28

Hamelraj

4,8464 gold badges21 silver badges42 bronze badges

3 Comments

SierraOscar Over a year ago

What if the sheet name has spaces in it? :)

Hamelraj Over a year ago

if your name my name then type like my name!

SierraOscar Over a year ago

sheet names with spaces, and some other characters in, need to be wrapped in single quotes. 'space name'!A1

Collectives™ on Stack Overflow

Compare multiple columns in multiple sheets excel

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related