Using VLOOKUP, MATCH to find info based on a variable date.

[Pspringer2002]

Hello Everyone,

I am trying to use VLOOKUP, Match to pull information from a variable date.
On the Daily Balance Sheet is the re-portable data which has a conditional cell(B2) for changing the date. On the Data by Date Sheet is the Table (_2015) with the raw data with columns by date an and rows by general account numbers. The formula I am using is =VLOOKUP(7310500.04,_2015,MATCH(B2,_2015,0),FALSE) but I keep getting an N/A.

I have attached the spreadsheet. Any suggestions would be helpful. I have also used INDEX and MATCH with the same results.


Thank You Phillip

[ChemistB]

Try this formula

=INDEX(_2015, MATCH(7310500.04, _2015[Gl '#],0), MATCH(TEXT(B2, "m/d/yyyy"), _2015[[#Headers],[7/1/2015]:[12/31/2015]],0)+2)

The headers are, by default, text so the date in B2 needs to be converted to text in the formula.

Note: I hard coded the GI # in since the values you have on your daily balance sheet in column A do not match exactly values in column B of your table.

[Pspringer2002]

Thank You ChemistB, that work.


Phillip

[Czeslaw]

You need to change the format and then your formula will work at the sheet "Date by Date".