paneliyadhruv
New Member
- Joined
- May 21, 2018
- Messages
- 36
Dear All,
Kindly help me to solve below mention problem.
In column A- master code from A2 to A
In column B- master code of fruit from B2 to B
In column C - list of fruits based on user entry
Procedure - Search column B name in column C, if name of that fruit present in column C then copy name in column E2 and master code of that fruit in column F. So on for searching of all cells of column B in column C and return values in E and F.
Kindly help me to solve below mention problem.
In column A- master code from A2 to A
In column B- master code of fruit from B2 to B
In column C - list of fruits based on user entry
Procedure - Search column B name in column C, if name of that fruit present in column C then copy name in column E2 and master code of that fruit in column F. So on for searching of all cells of column B in column C and return values in E and F.
Master Code Master List List based on User entry Output required with code code 1 apple grapefruit apple 1 1 apricot lemon apricot 1 2 avocado blueberry blueberry 4 3 banana boysenberry boysenberry 5 3 blackberry grapefruit 8 4 blackcurrant apple lemon 8 4 blueberry apricot melon 9 5 boysenberry nectarine 9 6 cherry melon orange 9 7 coconut nectarine pomegranate 14 7 fig orange quince 14 8 grape pomegranate 8 grapefruit quince 8 kiwifruit 8 lemon 8 lime 8 lychee 8 mandarin 9 mango 9 melon 9 nectarine 9 orange 10 papaya 11 passion fruit 11 peach 12 pear 13 pineapple 14 plum 14 pomegranate 14 quince 15 raspberry 16 strawberry 17 watermelon
<tbody>
</tbody>