Concatenate & vlookup

[ADAMC]

I've been trying for a while now to put a formula together but I am having no luck can anyone help me please?

formula I have:

=IFERROR(VLOOKUP(B7,'SHEET 1'!B:AA,26,FALSE),IF(N7<>"NO","FOUND",IF(P7<>"NO","ISSUED","NO ACTION")))

What I want to do is like this (Wrote in words so I can hopefully explain (I know this isn't right but hopefully someone sees what I mean

=IFERROR(VLOOKUP(B7,'SHEET 1'!B:AA,26,FALSE),IF(N7<>"NO"CONCATENATE("FOUND" & VLOOKUP(N7,SHEET 2,3,FALSE),IF(P7<>"NO","ISSUED","NO ACTION")))

Basically if N7 doesn't say NO I want to concatenate the word FOUND and the number from a VLOOKUP on the next sheet.

Thank you for any help

 

[mole999]

does the first formula work ?

 

[ADAMC]

Yes. Works exactly as I want just can’t seem to nest it properly. I always get an error.

Something like:

=IFERROR(VLOOKUP(B7,'SHEET 1'!B:AA,26,FALSE),IF(N7<>"NO,concatenate("FOUND", “ “,vlookup(..........,IF(P7<>"NO","ISSUED","NO ACTION")))

 

[mole999]

The other question I have is that when I apply this to a blank sheet the result is FOUND, so I would guess the logic is currently WRONG

So what logic should it follow