# easy excel question...

#### DanielG

##### New Member
Here's my mock data (there should be spaces between Jones and 1/5/05, David and 3/5/06, etc..):

Worksheet A:
Column A Column B
Jones 1/5/05
David 3/5/06
Lewis 2/3/03
Smith 12/6/06

Worksheet B:
Column A Column B
Jeffries
Jones
Smith
Steingold

What I need is a formula that will write in Column B of Worksheet B the
dates of any matching names (between Column A of Worksheet A and Column A of Worksheet B). So, for this example, the product of the formula would be that Column B (of Worksheet B) shows the dates for Jones + Smith, and would show nothing (meaning, a blank field) for the other names.

Thanks for any help!

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### mortgageman

##### Well-known Member
In Column B of the worksheet B, place this formula:

Code:
``=IF(ISERROR(VLOOKUP(A1,Sheet1!\$A\$1:\$B\$4,2,0)),"",VLOOKUP(A1,Sheet1!\$A\$1:\$B\$4,2,0))``

Gene, "The Mortgage Man", Klein

Replies
3
Views
141
Replies
3
Views
204
Replies
0
Views
364
Replies
5
Views
108
Replies
12
Views
499

1,171,281
Messages
5,874,824
Members
433,075
Latest member
DRubio

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

### Which adblocker are you using?

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

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