Return values from table

[Paula]

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.

 

[smartin]

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 (A14, "Single", 3)

 

[Max]

An index/match could also be used ..

Assume your posted table is within A14,
data in B24, row headers in A2:A4, col headers in B11

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

 

[Max]

=VLOOKUP (A14, "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
---

 

[smartin]

An index/match could also be used ..

Assume your posted table is within A14,
data in B24, row headers in A2:A4, col headers in B11

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.

 

[smartin]

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",A14,3,FALSE)

Sorry for the confusion.