Index and Match Issue

Viperlx

New Member
Joined
Mar 23, 2011
Messages
17
I am trying to grab a date from another sheet if a cell matches anything in another cell on another sheet. I hope the data below explains what I need. The formula would go into Sheet2 and B column.


Code:
=INDEX('Sheet1'!B:C,MATCH(A1,'Sheet1'!B:B,0),2)


Code:
Sheet1         Sheet2
A B              A        B
1 3:00          4         5:03
2 3:00          3         4:02
3 4:02          9          N/A
4 5:03
5 4:32
6 5:33
 
Last edited:

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Viperlx

New Member
Joined
Mar 23, 2011
Messages
17
Sorry, I wasn't specfic. I need to it match columns not specific cells.
 

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,700
Office Version
  1. 365
Platform
  1. Windows
Your example shows columns A and B in the respective sheets, but your formula implies columns B and C
Try:
Code:
=INDEX('Sheet1'!A:B,MATCH($A1,'Sheet1'!A:A,0),2)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top