Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to return exact match
The following looks in Uses! A:A to find a match for B189 and then looks in C
to find and return value, if present. IF(B189="","",IF(ISNA(VLOOKUP(B189,Uses!A:C,3,0)), "",VLOOKUP(B189,Uses!A:C,3,0))) I want now to return a particular value located in C:C Because there is now more than one possible matching record in Uses! A:A to match B189 and there may also be more than one non duplicate values in C:C the formula need to be able to know what value to return. To explain this better here is an example: B189 = €śToyota€ť €śToyota€ť can be found in Uses!A41, A42, A43,A44 In Uses!C:C some cells contain values, these are non duplicate values for !Toyota€ť Uses!C41 = hatchback Uses!C42 = salon Uses!C43 = Uses!C44 = compact If I just want to return €ścompact€ť what way does the formula need to be modified to give this result. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IINDEX and MATCH formula with more than one return value | Excel Discussion (Misc queries) | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Need a function to return EXACT row number of a match | Excel Worksheet Functions | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Linking sheet - Formula Match Exact or select next row and cell | Excel Discussion (Misc queries) |