One way:

=if(ISNA(MATCH(...)), "", INDEX(...))

In article ,
Greg B <Greg wrote:

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