Look Up More than one cell
I have many lines of data, from which I want to look up and return a value
for two values. For example, I want to see a product price for a specific
customer.
The data may change with lines being inserted or delated, so rather than
specifying the range I would like to look for two specific values, is this
possible?
|