Hi, I want to know if it is possible to vlookup data in different row and column?
Example of data:
<TBODY>
</TBODY>
And you want to vlookup from another sheet, a particular data (say profession) for the respective names.
To have something like:
<TBODY>
</TBODY>
Thanks
Example of data:
Ages</SPAN> | Gender</SPAN> | Color</SPAN> | Origin</SPAN> | Profession</SPAN> | |
James Bond</SPAN> | |||||
28yrs</SPAN> | male</SPAN> | dark</SPAN> | african</SPAN> | actor</SPAN> | |
Tom Brown</SPAN> | |||||
32yrs</SPAN> | male</SPAN> | fair</SPAN> | european</SPAN> | athlete</SPAN> | |
Kate Blue</SPAN> | |||||
18yrs</SPAN> | female</SPAN> | fair</SPAN> | asian</SPAN> | broadcaster</SPAN> |
<TBODY>
</TBODY>
And you want to vlookup from another sheet, a particular data (say profession) for the respective names.
To have something like:
Profession</SPAN> | |
James Bond</SPAN> | Actor</SPAN> |
Tom Brown</SPAN> | Athlete</SPAN> |
Kate Blue</SPAN> | Broadcaster</SPAN> |
<TBODY>
</TBODY>
Thanks