CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaimportrange
Marrbont Dispatch
Marrbont Dispatch

Reputation: 11

Index Match on 2 separate google sheets

Can you please help me with the index match formula with Google sheets on 2 different workbooks? I know the formula on a regular excel sheet but it just won't do the same with google sheets.

I tried the same formula with the regular excel sheet but it just won't work.

Upvotes: 1

Views: 1701

Answers (1)

player0
player0

Reputation: 1

try:

=IMPORTRANGE("1VYCPRlno-upguZFmf-dgVG8pXxkXXTx-OWt_VBv4d5c", "Sheet1A:Z")

note: chenge sheet name if needed

note2: first you will see ref error. hover your cursor over it and a button will popup. click on it to authorize the connection/link between your two spreadsheets

Upvotes: 1

Related Questions