Hello Everyone
I was after some help for a formula im working on for a register but im having a little trouble with putting together a formula. The spreadsheet itself consits of 12 tabs (one for each month) and then one other tab which is a daily summary. On the daily summay I have the following formula in column B :
=HLOOKUP($C$4,INDIRECT(TEXT($C$4,"mmmm")),3,FALSE)
which works great and brings back the information im after but it isnt ideal! Instead of using a cell refrence I want to refernce the name of the person so that the formula would look at the date and look at the name and bring back the results. Ive attached an example spreadsheet and how its currently working. Is there way to combine a vlookup with a hlookup? Im at a loss and really need to solve this! Ive attached an example spreadsheet.
Bookmarks