#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

#n/a response while using the match/index?
 

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

#n/a response while using the match/index?
 

What do you want returned when a match isn't found?

This will leave the cell blank:

=IF(ISNA(MATCH('Asset Inventory Sheet'!AK10,'Server Inv
Refresh'!O10:O950,0)),"",INDEX('Server Inv Refresh'!B10:B950,MATCH('Asset
Inventory Sheet'!AK10,'Server Inv Refresh'!O10:O950,0)))

Biff

"Greg B" <Greg wrote in message
...
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