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"

CodePudding user response：

you miss a comma:

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

and I2 is hopefully = 1

CodePudding user response：

Have you tried the IF statement?

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