I'm having a problem solving this problem below. I've tried vlookup's with if statements and they are not working. Any help would be appreicated. The answer on the first row is .015, 2nd row is .09 and the 3rd row is Blank.
The question is create a formula that will find the correct value based on both the value and age using the table to the right to find values. If value is blank then the formula should return a blank. See attached table.
Thanks
Sounds like homework but I'm bored so I'll bite:
E7: =IF(ISNUMBER($B7),INDEX($H$8:$J$13,MATCH($B7,$G$8:$G$13,0),MATCH($C7,$H$7:$J$7,0)),"")
You could also use VLOOKUP (so check out in XL help) as I suspect that's probably what they'd expect you to use.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks Donkeyote,
It works, I'll review the logic of your answer!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks