Nested IF Statement in VLOOKUP To Accomplish This?

[censo]

Hello,

I have a function that examines the first three characters of a string and then executes a VLOOKUP that returns the appropriate value. That works fine.

The challenge I'm having is including in that same formula an additional check that examines characters 5-7, or the value "FRT". The positioning will always be constant and fixed if hardcoded in, or if being searched for, only that sequence of "FRT" will ever be present so I know I would not receive false positives.

What would said function look like, do I need to nest an IF statement where it searches for "FRT", if not, run the above function I already have in place?

Thanks!

Excel 2013 32 bit
	A	B	C
1	SKU	CURRENT OUTCOME	DESIRED OUTCOME
2	WAL-123456	4	4
3	WAL-FRT-123456		10
Sheet1

Cell Formulas
Range	Formula
B2	=VLOOKUP(LEFT(A2,3),HANDLING,2,0)

Named Ranges
Name	Refers To	Cells
HANDLING	=Sheet2!$A$2:$B$3

Excel 2013 32 bit
	A	B
1	CODE	RESULT
2	WAL	4
3	FRT	10
Sheet2

 

[censo]

I think you should...

The solution met all of my requirements! Thanks Aladin.

 

[Aladin Akyurek]

The solution met all of my requirements! Thanks Aladin.

Thanks for the update.