[SOLVED] Checking If Matching Numbers Exist in Different Ranges

Problem:

Column A in Range1 contains numbers. Columns A & B in Range2 contain numbers and their matching text.
For each number in Range1, we want to find a match in Range2 and then copy that number\'s corresponding text to column B for Range1.

Solution:

Use the IF, ISNA, and VLOOKUP functions as shown in the following formula:
=IF(ISNA(VLOOKUP(A3,$A$9:$B$14,1,FALSE)),\"Not Found\",VLOOKUP(A3,$A$9:$B$14,2,FALSE))

I understand how one can look at multiple ranges in a given worksheet, but is it possible to use this or another formula to look at multiple worksheets in a given workbook. Please advise.