Hello,
I need to do a Vlookup using criteria from the columns and rows. For example:
<tbody>
</tbody>
In another sheet, I have the ID and class but not arranged in this order. The data is large and would be tasking to go through manually. The ID/Class are unique identifiers.
How do I go about it? Your prompt response would be appreciated
I need to do a Vlookup using criteria from the columns and rows. For example:
ID/CLASS | APPLE | BOY | CAT | DOG | EGG | FAN | GUN | HORN | INK |
1243 | 5,600 | 765 | 1,123 | ||||||
1445 | 2,434 | 112 | 445 | 9,400 | 2,454 | ||||
3243 | 3,001 | 223 | 7,210 | 222 | 30 | ||||
2112 | 3,233 | 211 | 448 | 101 | 2,444 | ||||
6756 | 9,312 | 1,121 | 9,989 | 1,443 | |||||
1111 | 1,121 | 9,656 | 7,121 | 1,212 |
<tbody>
</tbody>
In another sheet, I have the ID and class but not arranged in this order. The data is large and would be tasking to go through manually. The ID/Class are unique identifiers.
How do I go about it? Your prompt response would be appreciated