I have Sheet1 with the following info:
A B C
1 0001
2 0002
3 0003
4


Then I have Sheet2 with the following information:

A B C
1 0001 Switch-1 10.13.6.1
2 0001 Switch-2 10.13.6.2
3 0001 Router-1 10.13.6.3
4 0001 Router-2 10.13.6.4
5 0002 Switch-1 10.13.7.1
6 0002 Switch-2 10.13.7.2
7 0002 Router-1 10.13.7.3
8 0002 Router-2 10.13.7.4
9 0003 Switch-1 10.13.8.1
10 0003 Switch-2 10.13.8.2
11 0003 Router-1 10.13.8.3
12 0003 Router-2 10.13.8.4

I want Sheet1 in Column B to display the IP address of the matching site on
Column A (ex: 0001) for Router-1 from Sheet2.

Thanks in advance!