View Single Post
  #1   Report Post  
brianlee89 brianlee89 is offline
Junior Member
 
Posts: 2
Default 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:)