Test Sheet 1.xlsxTest Sheet 2.xlsx

Hello again, Excel Forum!

I have attached two files... Test Sheet 1 and Test Sheet 2.

I am trying to populate Test Sheet 1 with the info from Test Sheet 2 using the Equipment Number as the lookup value.

Normally, this isn't much of an issue, as I have often used the VLOOKUP function to search other sheets when there are unique numbers....

However, in this situation, Test Sheet 2 has my lookup value appearing 30 times on different rows.

Have any of you come across this issue before?

Any help/advice is appreciated.