View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L Smith L Smith is offline
external usenet poster
 
Posts: 6
Default use a function to look up a result in a spreadsheet

"Toppers"

Thanks for the offer. I still have problems and have sent a worksheet with
the sasmple data on it.

Very grateful for your assistance.

LS

"Toppers" wrote:

Both #N/As are occuring the MATCH against product and this error (often)
happens if there is (are) extra blank(s) in one of the fields being matched.
So check the data as it is a data error.

If problem persists, send me a w/book to toppers<atjohntopley.fsnet.co.uk
and I'll have look later today (after 16:00!).

HTH