Forum Discussion

Copper Contributor

Nov 20, 2020

Formula error in link to another spreadsheet

I am trying to fetch data from one spreadsheet into another. no matter which lookup formula I use, I get an error: There is a problem with this formula. Not trying to type a formula? When the f...

excel

Formulas and Functions

Gary_Bostock

Copper Contributor

Nov 25, 2020

Bennadeau =XLOOKUP(A47.'LISTINGS 2020.xlsx'!Code.'LISTINGS 2020.xlsx'!Description)

The formula is referencing cell A47 and is in a spreadsheet WCCOSTINGS, looking for source data contained in spreadsheet named LISTINGS 2020

Thanks

Bennadeau

Iron Contributor

Nov 25, 2020

Gary_Bostock

It seems like a simple vlookup would do the trick here.

=VLOOKUP(A47,'[LISTING 2020.xlsx]Sheet1'!$A:$B,2,0)

Change "sheet1" for the sheet name where your data is.

Change "$A:$B" for where your table is.

This reads: "Find the value located in A47 within column A of Listing 2020.xlsx, sheet1. Then return the value located right next to it (in column B).

I hope this helps.