in my worksheet i have 2 columns with data:
column A (a2:a83)--- customer names;
column B (b2:b83)--- number of boxes (coffee)they received
in some cells in column B there are the same numbers
(i.e. B13,B28,B32,B45,B68 = 750)
i want vlookup 750 in column B and return all the company
names which are in column A -- in cells D2:D6. i used
vlookup function but without any success, because vlookup
returns only first value.
Thank you.
column A (a2:a83)--- customer names;
column B (b2:b83)--- number of boxes (coffee)they received
in some cells in column B there are the same numbers
(i.e. B13,B28,B32,B45,B68 = 750)
i want vlookup 750 in column B and return all the company
names which are in column A -- in cells D2:D6. i used
vlookup function but without any success, because vlookup
returns only first value.
Thank you.