How to merge two formulas in to one formula

[Ingemar]

Hello Excel specialists,

I have two formulas I would like to merge:

First formula
=IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found")
This formula is checking if cell value of A8 exists in List 2


Second formula
=IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0))
This formula is checking if a cell in List 2 is blank. If not, the formula will return the cell value 9 columns to the right of the VLOOKUP cell.

Booth formulas above are working fine when they are separated. I am trying to merge the formulas like the example below but I get the message that "You've entered too many arguments for this function."

=IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found",IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0)))

Any kind of help is appreciated.

Kind regards

Ingemar

 

[Fluff]

Are the values that the formula returns text or numbers?

 

[Fluff]

Ignore my previous question, didn't realise you have three possible responses.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Try

=IF(ISERROR(VLOOKUP($A8,List2!A:T,9,0)),"Value not found",IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0)))

 

[Ingemar]

Hello Fluff,

Your formula works great. T H A N K Y O U very much for your help.

Kind regards

Ingemar

 

[Fluff]

You're welcome & thanks for the feedback.