How to do a lookup with 2 parameters?
Hi, I'm trying to create a decision support system. Currently, I'm using drop-down list for the decisions. I want to do some sort of lookup for 2 parameters, like a grid search. First via the row then the column and the result that I want to get is at the bottom of the table. Any kind soul that can help me? I've tried vlookup, lookup, index etc but all doesn't work. Thanks:)
|