Help with XLookup to change Search Ranges per a Selected Condition
Hello Xcel Pros,
I’ve used XLookup for a number of things, but I can find, figure out, or wrap my head around what I think could be easy enough to do, but I am just missing it, or I’m trying to force the wrong formula to do what I need. I created an example of my much larger workbook that should be sufficient to show what I’m going for, which is to add a Value to a Base Unit Stat Value, dependent upon a selected condition. In short I don’t know how get a Formula to search through the Title, Sub-Title to add that Value based on the Selected Condition and Unit.
Thank you!
Hello Xcel Pros, I’ve used XLookup for a number of things, but I can find, figure out, or wrap my head around what I think could be easy enough to do, but I am just missing it, or I’m trying to force the wrong formula to do what I need. I created an example of my much larger workbook that should be sufficient to show what I’m going for, which is to add a Value to a Base Unit Stat Value, dependent upon a selected condition. In short I don’t know how get a Formula to search through the Title, Sub-Title to add that Value based on the Selected Condition and Unit. Thank you! Read More