Google Sheets Double Sheet Reference

user_18909651 0
Viewed 41

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"

google-sheets-formula formula google-sheets
2 Answers

you miss a comma:

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

and I2 is hopefully = 1

user_56326290

Have you tried the IF statement?

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