Pivot returning values that are #N/A

[Newport Count]

i have a formula that looks up data from a pivot table....the pivot relates to a data request log and a pricing request log - both separate

the data request log and pricing request log includes data and pricing activities....some are only data, some only pricing, a few are both - each activity has its own unique request number - if both data and pricing then the request number will be the same

so the pivot looks up a request number eg F1.....it counts how many actions there are for this request number (eg request F1 may have 6 actions) and displays this number....

eg F1 data only request....6 actions.....no pricing activities/request...the pivot will display 6 under the column Data but then returns the value #N/A under the column pricing if no actions/request found for pricing...i want this to return "blank" if there are no actions/request found under either pricing or data

the formula used is as follows:

under the column named data:
=VLOOKUP(J7,'DATA PIVOT'!A7:D150,3,FALSE)

under the column named pricing:
=VLOOKUP(J7,'PRICING PIVOT'!A7:D150,3,FALSE)

i think that because FALSE is used this returns the value #N/A?

thanks!

[DonkeyOte]

Which version of XL are you using ?

If using XL2007 see IFERROR function

If 0 is a potentially valid result then I think you're left with:

Please Login or Register  to view this content.

Might be easier to post a sample file if unable to resolve.

[Newport Count]

Thanks - probably didnt explain it too well!

a basic IF ISNAVLOOKUP formula was all that was needed - pretty much the above

Appreciated!

[DonkeyOte]

If it's just as ISNA error you're capturing the MATCH would suffice (no need for VLOOKUP per se in that section of the formula).