How can I lookup when match has more than one value?
Hi,
May I request how to use vlookup or Index/Match combination to lookup the
drive utilization, for same hostname..
Server1 C:\ (2) 21478666240 17488568534 3990097706 81.42297263
Server1 D:\ (3) 2.9362E+11 68383018334 2.25237E+11 23.28963077
Server1 E:\ (4) 1.25325E+11 48705869576 76619192568 38.8636309
With Vlookup or Index/Match basic function use, I can get either the 1st
match or the last match, but not the middle one or the drive D. Any clue is
much appreciated.
Thankyou
"David Hilberg" wrote:
=IF( CountIf(a1:a10,"Joe")<1, CountIf(a1:a10,"Joe"),
LookUp(..etc...) )
will give you the count if there are more or fewer than one.
Otherwise, it performs the lookup.
- David
On Jul 23, 9:12 pm, bonot1 wrote:
I am using LOOKUP functions to retrieve info from a list. Some of the lookup
values have more than one match in the list. Is there a function that allows
me to retrieve multiple elements for one lookup value, or at least a function
that tells me there are duplicate matches?
|