Hey Chandoo peep's,
I have been set a challenge and, I have to admit, I am a little stumped.
(Alas, probably because of personal family health issues, brain is not quite engaged. Dad has been recently diagnosed with Lung Cancer.
)
I have a colleague at work whom needs to add up a table array of data, matching to certain words, if that is possible. I have put together a quick Excel example, of what we are trying to acheive, as the end result: 'Excel - Lookup Data for TG - 001.xlsx .
I initially thought (though, now hindsight, wrong!), of using VLOOKUP, but, then remembered INDEX and MATCH, but, it has been a long time.
My colleague will be entering data on one sheet tab, for 'Value's', 'Claim's' then each with a 'Status' of: Withdrawn; Agreed; Budget; and a couple of other terms.
We would like to create Summary where the row for the status of 'Budget', will lookup the table array for the many times 'Budget' appears and its values for respectively for 'Value' and 'Claim', can be added up to give a sub total.
I appreciate any guidance you can give me and look forward to your replies!
Thank you!
I have been set a challenge and, I have to admit, I am a little stumped.
(Alas, probably because of personal family health issues, brain is not quite engaged. Dad has been recently diagnosed with Lung Cancer.
)I have a colleague at work whom needs to add up a table array of data, matching to certain words, if that is possible. I have put together a quick Excel example, of what we are trying to acheive, as the end result: 'Excel - Lookup Data for TG - 001.xlsx .
I initially thought (though, now hindsight, wrong!), of using VLOOKUP, but, then remembered INDEX and MATCH, but, it has been a long time.
My colleague will be entering data on one sheet tab, for 'Value's', 'Claim's' then each with a 'Status' of: Withdrawn; Agreed; Budget; and a couple of other terms.
We would like to create Summary where the row for the status of 'Budget', will lookup the table array for the many times 'Budget' appears and its values for respectively for 'Value' and 'Claim', can be added up to give a sub total.
I appreciate any guidance you can give me and look forward to your replies!
Thank you!
