LinkBack URL
About LinkBacks
what is the formula to be in the yellow cell put to return the premium amount corresponding to the age in column b98:103 and sum inssured?
what is the formula to be in the yellow cell put to return the premium amount corresponding to the age in column b98:103 and sum inssured?
Try:Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
=index($c$4:$j$8,match($b12,$c$3:$j$3,1),match($c12,$b$4:$b$8,1))
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
And this
=LOOKUP(B12,$C$3:$J$3,INDEX($C$4:$J$8,MATCH($C12,$B$4:$B$8,1),1))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks