Forum Discussion
HOw to use, IF, AND, Lookup, match, maybe all or none of these!
Good evening/morning, I could do with some help on the example workbook I have added. What I am trying to acheive is this:- Include all of the relevant invoice numbers from sheet 2, onto shee...
OliverScheurich
This now works, thank you. There was problems in the real data, and also with formatting.
I have a further issues, I have noticed a lot of 'investtigation' needed. This is because there are employees who have had multiple entries, e.g. on sheet 1 same employee number with more hours.
I have added this on new rows on both worksheets and highlighted yellow. I would be most grateful if you could add some formula to be able to rectify this problem.
Many thanks in advance
This now works, thank you. There was problems in the real data, and also with formatting.
I have a further issues, I have noticed a lot of 'investtigation' needed. This is because there are employees who have had multiple entries, e.g. on sheet 1 same employee number with more hours.
I have added this on new rows on both worksheets and highlighted yellow. I would be most grateful if you could add some formula to be able to rectify this problem.
Many thanks in advance
Re:there are employees who have had multiple entries, e.g. on sheet 1 same employee number with more hours.
I guess the question will be intuitively clear if you share a sample file.
I guess the question will be intuitively clear if you share a sample file.
peiyezhu
You make a very valid point. Please now see attached updated sample workbook.
Many thanks in advance- That's right, but they are on different invoices, as they could be in the same period, but different weeks. (weeks not shown).