Return values from table
Paula wrote:
If I a have a set table like this:
Daily Termo Spring
Single 20 30 40
Double 30 40 45
Triple 35 45 55
And I have a set of data which changes daily, I want a formula to return the
number of minutes in the table if the day's job is a Single Room with a Termo
clean i.e. 30 minutes.
Is it possible? Thanks in advance.
VLOOKUP should be expeditious for your example, since there are few
categories to match:
=VLOOKUP (A1:D4, "Single", 3)
|