User Profile
Gkerr
Copper Contributor
Joined Aug 25, 2022
User Widgets
Recent Discussions
Index Match help - #Value error
Hi, I am looking for some help with the below: In cell D9, I am looking to return the % value in the table at the bottom of the screen shot. I want cell D9 to say find me the % value in the table if L9 is found in B16:B25 and if M9 matches D6. any help would be greatly appreciated. Thank youFormula to reference multiple cell ranges?
Hi I would greatly appreciate any help solving a lookup formula I need. I have inserted a screenshot where the yellow cell needs to return a date from row 5 if the "F'work" tag in column I matches those in column C and if there is a percentage figure in the date table i.e "BBB" in cell M6 has an uplift of 3%, so Apr-23 would need to be returned into the formula cell. NB. there will only be 1 percentage uplift per "F'work" tag. Thank you
