Replace N/A result with "New This Period" in a Vlookup formula

[robertguy]

Hi,

I am using the vlookup formula =VLOOKUP(C2,'Last Months Data'!C:C,1,0) which is retuning results as requested, however, is it possible to amend the formula so that any results returned as N/A would be retuned as "New This Period".

Any assistance in this matter would be gratefully appreciated

Many thanks in advance


Rob

N.B. Excel version 2007

[AliGW]

=IF(ISNA(VLOOKUP(C2,'Last Months Data'!C:C,1,0)),"New This Period",VLOOKUP(C2,'Last Months Data'!C:C,1,0)) should work.

[martindwilson]

Excel version 2007
=iferror(VLOOKUP(C2,'Last Months Data'!C:C,1,0),"new this period")

[AliGW]

Excel version 2007
=iferror(VLOOKUP(C2,'Last Months Data'!C:C,1,0),"new this period")

Won't this return the text phrase for any error, rather than just #N/A?

[robertguy]

AliGW & martindwilson

EXCELLENT !! - Many thanks for your (VERY) prompt replies they both worked a treat

Many thanks

Regards

Rob

[AliGW]

You're welcome, Rob!

[martindwilson]

=iferror(VLOOKUP(C2,'Last Months Data'!C:C,1,0),"new this period") what other error are you likely to get with vlookup? youll only get div/o or num errors if the result of the lookup is one of those

[AliGW]

=iferror(VLOOKUP(C2,'Last Months Data'!C:C,1,0),"new this period") what other error are you likely to get with vlookup? youll only get div/o on num errors if the result of the lookup is one of those

I was asking you!