Two Spread Sheets one Function Needed

[Allison]

I have two spreadsheets

Spreadsheet A List in column A - Grant Number

Spreadsheet B List in column A - Grant Number
column B - EIN Number

These two different spreadsheets are a result of
downloads from two different systems. I've been
ask to specifically use a VLookUp nested function to
take the unique identifier in sheet a & b which is
is the Grant Number and compare if they are an exact match
fill a new column B in Spreadsheet A with the EIN Number.
In order to perform a new data set for the system download
that does not have an EIN Number.

Help!!!!!

 

[Dave Peterson]

Put both worksheets in the same workbook (not necessary, but easier for me).

Put this formula in B1 of sheetA:
=vlookup(a1,sheetB!$a:$b,2,false)
and drag down.

This'll return #n/a if there's not a match:

You can hide that error by using this formula:

=if(iserror(vlookup(a1,sheetB!$a:$b,2,false)),"",
vlookup(a1,sheetB!$a:$b,2,false))

(all one cell.)