I have a list of numbers in 1 spreadsheet. I need it to go spreadsheet B and find it. However on spreadsheet B there are 5 tabs. If it can't find it on tab A, I want it to look on tab B and so on. I don't know if that would be a Vlookup/IF Statement combo or what. All I need it to do is bring back that number if it finds it.
Bookmarks