Vlookup Help

Hello,

I am completing an audit and have 2 spreadsheets with names, addresses, additional info, etc. I'm trying to create a lookup formula that will populate a cell in spreadsheet #2 if the name in spreadsheet #2, column A matches that of a name in spreadsheet 1, column A.

If this question makes sense, is this possible to do using the vlookup function?

Hi,



=IFERROR(VLOOKUP(A2,[Spreadsheet#2.xlsx]Sheet1!$A$2:$Z$1000,2,0),"")

=IFERROR(VLOOKUP(A2,[Spreadsheet#2.xlsx]Sheet1!$A$2:$Z$1000,3,0),"")

maybe I'd need a sample file to be more precise.

Hope it's a little step forward for your work.