Forum Discussion
Cara Pfaff
May 11, 2018Copper Contributor
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