# data matching

#### simonf

##### Board Regular
Book3
ABCDE
1JANFEBMARAPR
2APPLE(APO)42654566
3BANANA(BAN)26254535
4CHERRY(CHY)28349878
5ORANGE(ORG)12786348
Sheet1

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### simonf

##### Board Regular
Hi, I can't quite figure out what formula to use if I want to return the value of APO in Jan. Since APO is only part of the string in A2, I was thinking of the SEARCH function but just can't quite put it together. THanks.

#### Mark W.

##### MrExcel MVP
Are we playing Jeopardy... and, we have to supply an "answer" in the form of a question?

#### simonf

##### Board Regular
Hi, I can't quite figure out what formula to use if I want to return the value of APO in Jan. Since APO is only part of the string in A2, I was thinking of the SEARCH function but just can't quite put it together. THanks.

#### Mark W.

##### MrExcel MVP
Book1
ABCDEFGHIJKLMN
1JANFEBMARAPR42
2APPLE(APO)42654566
3BANANA(BAN)26254535
4CHERRY(CHY)28349878
5ORANGE(ORG)12786348
6
7
8
9
Sheet1

##### MrExcel MVP
Select A1:E5 and name it Table (using e.g., the Name Box).

Enter APPLE (APO) in A9.

Enter JAN in B9.

In C9 enter:

=INDEX(Table,MATCH(CHAR(42)&A9&CHAR(42),INDEX(Table,0,1),0),MATCH(B9,INDEX(Table,1,0),0))

which is as swift as you can get.

Note. CHAR(42) is a *. The way the lookup value is set up for the first MATCH use it for clarity.

#### simonf

##### Board Regular
Ok, I inserted an extra blank roll A and use this formula to return the value matching APO but still can't figure out how to match the month yet.
This message was edited by simonf on 2002-10-15 17:17

#### simonf

##### Board Regular
Just beat me to it. Thanks Aladin.

Thanks Mark.

Replies
7
Views
253
Replies
0
Views
139
Replies
3
Views
83
Replies
6
Views
195
Replies
3
Views
274

1,181,685
Messages
5,931,414
Members
436,788
Latest member
Oteez

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