dallascowboys
New Member
- Joined
- Oct 10, 2018
- Messages
- 8
ID1 | ID2 | Name | |
001 | A012 | John Smith | |
002 | B038 | Will Johnson |
<tbody>
</tbody>
Here is what I struggled, some of our employees have 2 IDs, this is what I want: If vlookup the ID1, if return is "#N/A", then I want to vlookup ID2 to return a name. (which should come up with name).
How do I put one formula together? I tried to use if(vlookup) but it doesn't work.
Thanks for the help!