Index Match on 2 separate google sheets

0
votes

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.

1
google-sheetsgoogle-sheets-formulaimportrange
Have you tried using importrange? – Draken
Hi! I've been trying to do the importrange formula but it doesn't seem to work.... – Marrbont Dispatch
this is the first workbook -- this is where the data comes from.... docs.google.com/spreadsheets/d/… – Marrbont Dispatch
this is the second workbook where I need a data from the first workbook to show up docs.google.com/spreadsheets/d/… – Marrbont Dispatch
sheets are private – player0

1 Answers

0
votes

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