CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulaformula
Patrick Regan
Patrick Regan

Reputation: 11

Google Sheets Double Sheet Reference

I have two sheets in the same workbook. I need to pull data to the first based off information in both.

This is my current format I'm working on:

=VLOOKUP(DATEVALUE(TEXT(E2,"mm/dd/yyyy")),VIX!A2,I2)

I need it to do this basically: If the date in E2 matches the date in A2 on sheet "VIX" then return the data in cell I2 on sheet "VIX"

Upvotes: 1

Views: 50

Answers (2)

Gabriel Pierce
Gabriel Pierce

Reputation: 406

Have you tried the IF statement?

=IF(DATEVALUE(TEXT(E2,"mm/dd/yyyy")) = 'VIX'!A2, 'VIX'!I2, "E2 does not match VIX I2")

Upvotes: -1

player0
player0

Reputation: 1

you miss a comma:

=VLOOKUP(DATEVALUE(TEXT(E2, "mm/dd/yyyy")), VIX!A2, I2, )

and I2 is hopefully = 1

Upvotes: 2

Related Questions