Hi,
Assuming these are 2 seperate lists in different tabs
I would like to return the value in the second column as it is the closest match.
Is this possible?
If I wanted to return the first column i would use vlookup("*"&a1....
<tbody>
</tbody>
any help is greatly appreciated
Anthony
****** id="cke_pastebin" style="position: absolute; top: 93px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
Assuming these are 2 seperate lists in different tabs
I would like to return the value in the second column as it is the closest match.
Is this possible?
If I wanted to return the first column i would use vlookup("*"&a1....
Rehab Support Worker | Support Worker |
Assistant Support Worker | Support Worker |
Accommodation Support Worker | Support Worker |
Assistant Accountant | Accountant |
Management Accountant | Accountant |
Deputy Accountant | Accountant |
<tbody>
</tbody>
any help is greatly appreciated
Anthony
****** id="cke_pastebin" style="position: absolute; top: 93px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
Support Worker |
<tbody>
</tbody>