match statements

[Greg B]

Good Morning

I am hoping you can help me with this. I have been working on this for
awhile.
This formula I am using is doing an index and a match on another tab of the
workbook and the formula looks like this at this point

=IF(ISNA(INDEX('Server Inv Refresh'!$B$2:$B$1000,MATCH('Asset Inventory
Sheet'!AK2,'Server Inv Refresh'!$O$2:$O$1000,TRUE))),0,INDEX('Server Inv
Refresh'!$B$2:$B$1000,MATCH('Asset Inventory Sheet'!AK2,'Server Inv
Refresh'!$O$2:$O$1000,TRUE)))

Problem is that there are could be multiple matches or none. How would I
include other variables for example (To determine if one line may be retired
or disposed).

Any help anyone could offer would be greatly appreciated. Thank you

 

[rdwj]

Greg,

Looks like you are trying a vlookup but then accross multiple workbooks and
with an non-sorted array. Formula looks fine, however I don't understand why
you use an ISNA as you also use the argument TRUE in the MATCH function,
which means that the Match will always return a value. What is it that you
are trying to do? Based on the formula
find the value in 'Asset Inventory Sheet'!AK2 in the array 'Server Inv
Refresh'!$O$2:$O$1000 and
use the position where this is found to lookup a value in 'Server Inv
Refresh'!$B$2:$B$1000 ?

I don't really follow your question - but if the first array O2:O1000 has
got values that appear multiple times then a match will not give you the
second apperance of the value, unless you do a COUNTIF, and start a second
match there were the first value was found (and repeat based on COUNTIF).
What other variables are you talking about? Try specifying your problem
better - as I don't understand it.....