Excel 2007 not sure if I can use Vlookup and if statement

August 14, 2012 at 16:09:55
Specs: Windows 7
In excel 2007 I have a budget sheet that is by day for the entire year in the first column, and then next to that I have a column for expenses. I need the formula to look at another spread sheet and search for a a specific date within a column, so lets say the 1st of the month. If the date is there I then need the sales amount that is on the same row but different column associate with the date to then populate that amount onto the expense column in the first spreadsheet.

See More: Excel 2007 not sure if I can use Vlookup and if statement

Report •


#1
August 14, 2012 at 16:21:28
So why do you think that you can't use VLOOKUP?

Have you tried it?

As long as the dates in both spreadsheets match exactly, and the dates in the "second" spreadsheet are in a column to the left of the expense column, it should work.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question