Hi guys
I am struggling with an index and match formula if anyone knows any good references of where I can learn it please advise, every time I search I find the tutorials too complicated and it would save me having to ask each time.
This is what I need help with please....
I require an index and match or sumproduct formula which does the following:
I need the formula to match B10 on the “UserSheet” with Row 3 on the “Act units” sheet and then I need it to match =B35&C35&D35&E35&F35 on the “UserSheet” with that of column G on the “Act Units” sheet
I have uploaded an example file, I need a formula in the green highlight column.
Can anyone help please?
Bookmarks