Formula Help: IF and Vlookup combination

[dallascowboys]

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!

 

[Indystick]

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

 

[dallascowboys]

Of course! duh.. Thank you so much!