Formula to Vlookup and if error (#N/A) return value of the cell two to the right

[Knockoutpie]

Hey everyone, long time browser, and i've been able to find many of my answers to questions on here. However i'm having one question stop me in my tracks.

How can i get IFERROR or something similar to return the value of the cell in column P

My vlookup is as follows

Range("M2").Select
ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-6],RC[-5],RC[-3])"

Or can be translated as

=VLOOKUP(M2,'[Common Report_Inv.xls]Common Report_Inv'!$K:$L,2,FALSE)

I'm trying to get it to when there is #N/A it will then return the value of the cell to the right (column P)

The result of the vlookup returns the value to M. But occasionally it will return an Error (#N/A) because no matching results are found. I would like it to return the value of two cells to the right in P.

Thanks for any help, i'm able to answer questions to clarify further

 

[Asala42]

Do you mean something like this?

=IFERROR(VLOOKUP(M2,'[Common Report_Inv.xls]Common Report_Inv'!$K:$L,2,0),P2)

 

[Knockoutpie]

Do you mean something like this?

=IFERROR(VLOOKUP(M2,'[Common Report_Inv.xls]Common Report_Inv'!$K:$L,2,0),P2)

So simple..

Thank you! Looks like my IfError formula was referencing a value to input on error and not a cell value

Guess I shouldn't have used " "
=IFERROR(VLOOKUP(M2,'[Common Report_Inv.xls]Common Report_Inv'!$K:$L,2,0),"P2")

 

[Knockoutpie]

Is there any chance you can also have the formula specify IF NULL then return value of P2? I know it's quite a few arguments in this formula already. The formula you provided works great for no value (#N/A) returned, but occasionally there will be NULL in the field instead of an N/A