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.