Forum Discussion

Cara Pfaff's avatar
Cara Pfaff
Copper Contributor
May 11, 2018

VLOOKUP ISNA and Calculate Value

Hi All,

 

I'm stuck.  Scenario:

I have tabs for each Month, on those tabs is an invoice amount for a company.  I need to subtract Current Month invoice amount from Previous Month invoice amount and I'd liketo hide the #N/A.  I can't figure out how to properly incorporate the ISNA function.  Could be doing it all wrong!  Help is appreciated :)

 

=CurrentMonthInvoiceAmount -( VLOOKUP(PreviousMonth,invoiceamountcolumn#,FALSE))

 

How can incorporate an ISNA or IFERROR and hide those darn N/A values.

No RepliesBe the first to reply

Resources