dallascowboys
New Member
- Joined
- Oct 10, 2018
- Messages
- 8
A | B | C |
ID1 | ID2 | Name |
001 | A010 | John Smith |
<tbody>
</tbody>
Hi All,
I need some help here.
basically, some of my employees have 2 IDs, If I vlook A, return is N/A, then I should be able to vlook B to get the name "john Smith".
how can i put that logic into one formula?
Thanks,