Return values from table
 

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.

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)

Return values from table
 

An index/match could also be used ..

Assume your posted table is within A1:D4,
data in B2:D4, row headers in A2:A4, col headers in B1:D1

Assume you have the paired inputs in F2:G2 down,
eg in F2: Single, in G2: Termo

then you could place this in H2:
=INDEX($B$2:$D$4,MATCH(F2,$A$2:$A$4,0),MATCH(G2,$B $1:$D$1,0))
to return the intersection data, viz: 30

Copy H2 down to return correspondingly for other paired inputs in F3:G3,
F4:G4, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---
"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.

Return values from table
 

=VLOOKUP (A1:D4, "Single", 3)

Think the vlookup should be something like this:
=VLOOKUP("Single",$A$1:$D$4,MATCH("Termo",$A$1:$D$ 1,0),0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---

Return values from table
 

Max wrote:
An index/match could also be used ..

Assume your posted table is within A1:D4,
data in B2:D4, row headers in A2:A4, col headers in B1:D1

Assume you have the paired inputs in F2:G2 down,
eg in F2: Single, in G2: Termo

then you could place this in H2:
=INDEX($B$2:$D$4,MATCH(F2,$A$2:$A$4,0),MATCH(G2,$B $1:$D$1,0))
to return the intersection data, viz: 30

Copy H2 down to return correspondingly for other paired inputs in F3:G3,
F4:G4, etc

Definitely. A very nice scalable alternative.

Return values from table
 

Max wrote:
=VLOOKUP (A1:D4, "Single", 3)

Think the vlookup should be something like this:
=VLOOKUP("Single",$A$1:$D$4,MATCH("Termo",$A$1:$D$ 1,0),0)

Oh duh (me). That's what I get for not proofing my posts. Of course I
meant (for a simple VLOOKUP), was:

=VLOOKUP("Single",A1:D4,3,FALSE)

Sorry for the confusion.