Match lookup

[texasalynn]

I need a way to lookup and return only part of a field. I have a table with account number and a field that I only want the first 2 digits and then in another field the mid(3,3). With the sample data I need from column D to get this from. I hope this makes sense.

Book1
	A	B	C	D
1	Dist-Acct	Acct	SERVCLOC#	SysCd
2	0240-1236884	1236884	00001	12
3	0240-1236884	1236884	00001	70
4	0260-0022783	0022783	00001	10
5	0260-0022783	0022783	00001	71
6	1625-0156877	0156877	100	0100900
7	0326-0482414	0482414	100	0100900
Sheet1

texasalynn

 

[Aladin Akyurek]

What must be looked up and where?

 

[texasalynn]

On a separate sheet I am looking up the dist-account number to get the two pieces of information from this sheet. My example is only a small portion of the workbook.

HTH
texasalynn

 

[Aladin Akyurek]

On 2002-09-17 10:10, texasalynn wrote:
On a separate sheet I am looking up the dist-account number to get the two pieces of information from this sheet. My example is only a small portion of the workbook.

HTH
texasalynn

The example table has the following fields:

{"Dist-Acct";"Acct";"SERVC LOC";"#Sys Cd"}

Let 0240-1236884 be our lookup value.

What must be returned as results from which columns, given the foregoing lookup value?

 

[texasalynn]

The example table has the following fields:

{"Dist-Acct";"Acct";"SERVC LOC";"#Sys Cd"}

Let 0240-1236884 be our lookup value.

What must be returned as results from which columns, given the foregoing lookup value?

Those are only going to have the two digits returned for this first selection.
My second table has
"Dist-Acct";"SERVC LOC";"BT";"SYS"}
So in the BT column I would have from the Sys CD the '12' and the SYS column would be blank.

Does that help?
texaslynn

 

[Aladin Akyurek]

On 2002-09-17 10:44, texasalynn wrote:

The example table has the following fields:

{"Dist-Acct";"Acct";"SERVC LOC";"#Sys Cd"}

Let 0240-1236884 be our lookup value.

What must be returned as results from which columns, given the foregoing lookup value?

Those are only going to have the two digits returned for this first selection.
My second table has
"Dist-Acct";"SERVC LOC";"BT";"SYS"}
So in the BT column I would have from the Sys CD the '12' and the SYS column would be blank.

Does that help?
texaslynn

I'm unable to visualize what is required. Since I was also unable to get the answer I needed to the questions I posed, I can do two things: either give up or make a wild guess. Does what you're looking for looks like:

=LEFT(VLOOKUP(E1,$A$1:$B$4,2,0),2)

=MID(VLOOKUP(E1,$A$1:$B$4,2,0),3,3)

where E1 houses a lookup-value and $A$1:$B$4 a lookup table?

There is no control for errors in these formulas yet.

 

[texasalynn]

Sorry to frustrate you Aladin! That is exactly what I needed. I didn't know you could do that with a formula. So I learned something new. So simple!!!!!



Thank you so much
texasalynn