Home |
Search |
Today's Posts |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Lookup | Excel Worksheet Functions | |||
using MATCH, and LOOKUP | Excel Worksheet Functions | |||
match, lookup ??? | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup or Match | Excel Worksheet Functions |