Hello
I'm wondering if its possible to add an additional range of cells to some of the original range when doing a VLOOKUP?
For example please refer to my attachments
In cell C5 of the 'Breakdown checklist' there is a vlookup which has pulled through the hours from the 'Jan 18 overtime & shift' in cell F3. I have taken it out for the purpose of this post as I didn't want to share the file path but the formula reads;
=VLOOKUP(A5,'S:\File Path not shared\[January 18 Overtime & Shift.xlsx]Monthly Accrual'!$B$1:$G$56,5,0)
What I would like to do next is have the same formula in cell C9 of the breakdown checklist so that it pulls through the hours from cell I3 of the Jan 18 overtime & shift. I will still need to include the data from column B-D but instead of picking up F and G I need to pick up I and J. Is this possible?
If so, then so on and so fourth for 'Time @ 2', 'Shift Premium' and 'O/Time on shift'.
There are numerous names below 'Joe Bloggs' so I'm assuming the formula can just be copied down and will work.
Bookmarks