View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg B Greg B is offline
external usenet poster
 
Posts: 3
Default #n/a response while using the match/index?

Good afternoon
I am trying to use a match index formula to pull up serial numbers. The
problem I am having is that if it doesn't find a match, it is providing an
#n/a error. This is of course affecting other formulas.

The formula is: =INDEX('Server Inv Refresh'!B10:B950,MATCH('Asset
Inventory Sheet'!AK10,'Server Inv Refresh'!O10:O950,FALSE))

Any help I would appreciate it.

Thank you