Formula Help: If and Vlookup

[dallascowboys]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]ID1[/TD]
[TD]ID2[/TD]
[TD]Name[/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]A010[/TD]
[TD]John Smith[/TD]
[/TR]
</tbody>[/TABLE]

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,

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-help-if-vlookup-combination.html#post5208584

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.