how do i retrieve data from multiple parameters?

[geo chevko]

i need to enter 2 paramters to find a product.

para.1 para.2 answer
2" pipe $2

pipe is a vertical lookup & 2" is horizontal. both are in a different
worksheet

 

[Spiky]

i need to enter 2 paramters to find a product.

para.1 para.2 answer
2" pipe $2

pipe is a vertical lookup & 2" is horizontal. both are in a different
worksheet

How do they inter-relate if they are in different sheets? Where does
the $2 answer actually come from?

 

[geo chevko]

How do they inter-relate if they are in different sheets? Where does
the $2 answer actually come from?

Actually all 3 items are in a database spreadsheet in one row. we can
choose pipe and then a size. does that help. New to this.

 

[Fred Smith]

No it doesn't help. First you said "pipe is a vertical lookup & 2" is
horizontal. both are in a differentworksheet". Next you said "Actually all 3
items are in a database spreadsheet in one row". So which is it?

Then you say "we can choose pipe and then a size". If so, doesn't that get
you the answer you want?

If not, tell us:
-- the layout of your data
-- what answer you are looking for (examples are best)
-- what solution you are looking for (a formula, a procedure, instructions
on how to use the Find feature or Data Filter feature)

Regards,
Fred.

 

[dlyon]

No it doesn't help. First you said "pipe is a vertical lookup & 2" is
horizontal. both are in a differentworksheet". Next you said "Actually all 3
items are in a database spreadsheet in one row". So which is it?

Then you say "we can choose pipe and then a size". If so, doesn't that get
you the answer you want?

If not, tell us:
-- the layout of your data
-- what answer you are looking for (examples are best)
-- what solution you are looking for (a formula, a procedure, instructions
on how to use the Find feature or Data Filter feature)

Regards,
Fred.

I found this question in the group. this is real close. i tried the
formula for this which follows:
value by two or more columns. (e.g. I want to ask for "column 1 = 1" AND
"column 2 = 5" to get the result "pears".

Column 1 Column 2 Column 3
1 5 apples
1 10 oranges
3 5 pears

{=OFFSET(E11,MAX(ROW(1:6)*--(B12:B17="John")*--(C12:C17="Nov")),0)}
' or
'Forumla Example 2:
'Using cell references as the search criteria in EXAMPLE 1:
'{=OFFSET(E11,MAX(ROW(1:6)*--(B12:B17=A6)*--(C12:C17=A7)),0)}

I tried this "exactly" but it will not work. the cntrl, shft, enter thing.
dont know if i am doing it in the wrong sequence or what. But this is the
closest to what i am trying to accomplish. sorry for the bad directions, and
thanks.

dan>

 

[Fred Smith]

The most likely problem is you are not entering the array formula properly.
You need to do the following:

1. Do *not* enter the braces surrounding the formula. Enter the formula
without the braces.
2. When you've finished typing, hit Ctrl-Shift-Enter.
3. Excel will respond by putting the braces around the formula, which tells
you you've entered it properly.

Let us know how it works out.

If you want a simpler (to me) method, build a helper column which =a1&b1.
Then you can use a standard Vlookup.


Regards,
Fred.

 

[geo chevko]

The most likely problem is you are not entering the array formula properly.
You need to do the following:

1. Do *not* enter the braces surrounding the formula. Enter the formula
without the braces.
2. When you've finished typing, hit Ctrl-Shift-Enter.
3. Excel will respond by putting the braces around the formula, which tells
you you've entered it properly.

Let us know how it works out.

If you want a simpler (to me) method, build a helper column which =a1&b1.
Then you can use a standard Vlookup.


Regards,
Fred.

Thanks Fred, that was simple on the cntrl.shft,enter.

Here is a shap shot of my spreadsheet.

Sheet 1 Sheet 2
para-1 para-2 result parameter data
col1 col2 col3 col 1 col2 col3 col4
col5 col6 col7
11/4" pipe f1 $2.00 1" pipe f1 $1.00
f2 $1.50 f3 $2.00
11/2" pipe f2 $2.50 11/4" pipe f1 $1.50 f2
$2.00 f3 $2.50
2" pipe f1 $2.50 11/2" pipe f1 $2.00 f2
$2.50 f3 $3.00
1" pipe f3 $2.00 2" pipe f1 $2.50 f2
$3.00 f3 $3.50

dan