Please show us a sample of what your data looks like. Use XL2BB to upload that sample.
Dog Name | Dog type | Type of request | Reference ID # | Client | Location | Cost | Account | CVV Code |
#N/A | #N/A | #N/A | 2 | 123456 | 500 | |||
Hello Peter. Please see answers to your questions below.1. Do those #N/A cells contain formulas or are they text values?
2. Is there likely to be any other error values on the sheet (eg #VALUE!, #DIV/0! etc)?