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

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.....

"Greg B" wrote:

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