Combining Formulas

[Justinian]

How do I combine these two formulas?

=VLOOKUP(A4,Units,2,FALSE)

=MID(A4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")),1)

 

[Marcelo Branco]

[TABLE="width: 137"]
<tbody>[TR]
[TD]4308K[/TD]
[TD]L1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4908K[/TD]
[TD]L2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]4805J[/TD]
[TD]L1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1812[/TD]
[TD]L1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is it the Units named range?
What about A4 that is used in MID(A4,....)

M.

 

[Justinian]

Can I e-mail you my workbook?

 

[Justinian]

Units named range is just a bunch of suite numbers. The VLOOKUP finds the suite number from that named range and the MID formula extracts the number.

 

[Marcelo Branco]

Can I e-mail you my workbook?

Private support is not recommended in this forum. To increase your chances of getting help you need to explain exactly what you are trying to do. And, sorry to insist, a sample of your data is essential.

M.

 

[Justinian]

I posted a sample. That is all the data I have right now.

 

[Justinian]

My penultimate post explains what I am trying to do.

 

[Marcelo Branco]

Units named range is just a bunch of suite numbers. The VLOOKUP finds the suite number from that named range and the MID formula extracts the number.

Are you saying that the MID function is used to extract some text from the result provided by VLOOKUP?
Something like
=MID(VLOOKUP(....),...)
Is it?

M.

 

[Justinian]

The MID extracts a number from the text. SO Twr2S#1 becomes 2 when using the MID formula.

 

[Justinian]

The VLOOKUP returns the Twe2S#1 so I want to combine the formulas so I just get the number instead of Twr2S#1.

 

[Marcelo Branco]

I took a look at your file (a tedious work uff ...) and noticed that these are the possible texts returned by VLOOKUP.

[TABLE="class: grid"]
<tbody>[TR]
[TD]

Twr St​

[/TD]
[/TR]
[TR]
[TD]

Twr 1B​

[/TD]
[/TR]
[TR]
[TD]

Twr 2Bd​

[/TD]
[/TR]
[TR]
[TD]

Twr 2 U​

[/TD]
[/TR]
[TR]
[TD]

Twr2 GK​

[/TD]
[/TR]
[TR]
[TD]

G 1B L​

[/TD]
[/TR]
[TR]
[TD]

G 1BLU​

[/TD]
[/TR]
[TR]
[TD]

G 1LKU​

[/TD]
[/TR]
[TR]
[TD]

G 1U U​

[/TD]
[/TR]
[TR]
[TD]

G 2B​

[/TD]
[/TR]
[TR]
[TD]

Twr2S#1​

[/TD]
[/TR]
[TR]
[TD]

T1Sig#5​

[/TD]
[/TR]
</tbody>[/TABLE]


Could you, please, tell us the expected result for each of these cases.

M.