Need help to nest formula with multiple arguments

[rebubula]

Hi All-

I am trying to configure a formula that will use all of the following:

IF
ISNA
VLOOKUP
LEFT
TRIM
UPPER
SUBSTITUTE

Here is what I have working so far: =IF(ISNA(VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE)),LEFT(TRIM(SUBSTITUTE(D2,",","")),10),VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE))

Here is what I need:=IF(ISNA(VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE)),LEFT(Upper(TRIM((SUBSTITUTE(D2,",","")),10),VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE))

But I keep getting the "You have entered too many arguments for this function" error. What is the trick to ordering these arguments?

Thanks in advance!

 

[Aladin Akyurek]

Hi All-

I am trying to configure a formula that will use all of the following:

IF
ISNA
VLOOKUP
LEFT
TRIM
UPPER
SUBSTITUTE

Here is what I have working so far: =IF(ISNA(VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE)),LEFT(TRIM(SUBSTITUTE(D2,",","")),10),VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE))

Here is what I need:=IF(ISNA(VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE)),LEFT(Upper(TRIM((SUBSTITUTE(D2,",","")),10),VLOOKUP(D2,'Line Table'!1:1048576,2,FALSE))

But I keep getting the "You have entered too many arguments for this function" error. What is the trick to ordering these arguments?

Thanks in advance!

Perhaps...

=IFERROR(VLOOKUP(D2,'Line Table'!$A$1:$B$1048576,2,0),
   UPPER(LEFT(TRIM(SUBSTITUTE(D2,",","")),10)))

 

[rebubula]

Works great! Thanks!

 

[Aladin Akyurek]

Works great! Thanks!

You are welcome. Thanks for providing feedback.