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

G

Greg B

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
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match statements 1
Ignore #N/A error using Index and Match Functions 1
hiding an error value, using INDEX/MATCH 3
Combination of INDEX MATCH FREQ ROW INDIRECT - find unique values using2 conds with UIDs that may ha 0
Using index and match 5
INDEX/MATCH automatic updates while source files are closed 5
Using INDEX & MATCH to search different columns 3
trouble with (complicated) vlookup searching another workbook 2

Top