Formula Help: IF and Vlookup combination

[dallascowboys]

[TABLE="width: 500"]
<tbody>[TR]
[TD]ID1[/TD]
[TD]ID2[/TD]
[TD]Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]001[/TD]
[TD]A012[/TD]
[TD]John Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]002[/TD]
[TD]B038[/TD]
[TD]Will Johnson[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!

 

[Indystick]

=IFNA(VL1,VL2) where VL1 and VL2 are your two lookups.

 

[dallascowboys]

Of course! duh.. Thank you so much!