# Index Match with Wildcard

#### Traveltime

##### New Member
 A Line Description-Located on 1st Worksheet B Expense Type - Located on 1st Worksheet C Vendor Name - Located on 2nd Worksheet D Type - Located on 2nd Worksheet AMEX Reclass - 35965 (these number change) Results goes from column D AAA-AAA Taxes BBB-BBB The result would be Earnings from Column D BBB-BBB Earnings AMEX Reclass - 35784 (These numbers change) The result would be Award from column D AMEX RECLASS Award AMEX - 57896 (These numbers change) AAA-AAA The result would be Taxes from Column D

<tbody>
</tbody>

Column C and D is a table in separate worksheet from columns A and B. I need an index match to search column C and the corresponding row from Column D in Column B of the first worksheet. There isn't an exact match between column A and C so I think I need a wildcard.

Hopefully this makes sense.

Thank you!

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Maybe something like this:

ABCD
1Line Description-Located on 1st WorksheetExpense Type - Located on 1st WorksheetVendor Name - Located on 2nd WorksheetType - Located on 2nd Worksheet
2AMEX Reclass - 35965 (these number change)AwardAAA-AAATaxes
3BBB-BBBEarningsBBB-BBBEarnings
4AMEX Reclass - 35784 (These numbers change)AwardAMEX RECLASSAward
5AMEX - 57896 (These numbers change)
6AAA-AAATaxes

</tbody>
Sheet1

Worksheet Formulas
CellFormula
B2=IFERROR(LOOKUP(2^16,SEARCH(Sheet2!\$C\$2:\$C\$4,A2),Sheet2!\$D\$2:\$D\$4),"")

</tbody>

<tbody>
</tbody>

I didn't receive an error or N/A but it returns an empty cell rather than the match in column D of the table.

The IFERROR on the formula will prevent any error from showing up. I'm at a loss why the formula doesn't work for you. The basic idea with the B2 formula is that it looks down the values in column C, and sees if any of them are found in A2. Since it found "AMEX RECLASS", it returned the value from the equivalent D column, D3=Award.

So if you changed the values from column C so they don't match anything in column A, you'd get an empty cell.

Replies
24
Views
822
Replies
2
Views
199
Replies
1
Views
215
Replies
1
Views
79
Replies
1
Views
448

1,217,482
Messages
6,136,910
Members
450,030
Latest member

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