I have a table with a list of names can be up to 1000 rows and values in 2 columns. So for small example:
I want to search for the following values so that I can get the names. The values can either be in Column B or C or both. I want to paste the numbers I'm looking for in column G and the results to appear in Column H and I
24
38
45
71
40
88
I would then like to see the results as follows with duplicate numbers highlighting the entire row.
Amal | 71 | 75 |
Blackcurrant | 38 | 38 |
Cantaloupe | 100 | 100 |
Cempedak | 37 | 37 |
Cherimoya (Custard Apple) | 87 | 88 |
Elderberry | 77 | 77 |
Feijoa | 87 | 87 |
Fig | 54 | 45 |
Grape | 9 | 9 |
Grapefruit | 21 | 21 |
Guava | 24 | 24 |
Loganberry | 76 | 76 |
Lychee | 86 | 80 |
Mangosteen | 91 | 91 |
Melon | 71 | 71 |
Miracle fruit | 94 | 94 |
Mulberry | 74 | 74 |
Pineberry | 42 | 42 |
Plum | 4 | 14 |
Plumcot (or Pluot) | 89 | 89 |
Salmonberry | 15 | 15 |
Tayberry | 38 | 36 |
Watermelon | 40 | 40 |
Yuzu | 75 | 75 |
I want to search for the following values so that I can get the names. The values can either be in Column B or C or both. I want to paste the numbers I'm looking for in column G and the results to appear in Column H and I
24
38
45
71
40
88
I would then like to see the results as follows with duplicate numbers highlighting the entire row.
24 | Guava |
38 | Tayberry |
38 | Blackcurrant |
45 | Fig |
71 | Melon |
71 | Amal |
40 | Watermelon |
88 | Cherimoya (Custard Apple) |