Help required ....
 

Need to know if a cell value equals to a value in a range of cells in
a row or column can I get the values under that matching cell..

For example...
I gave Ref name NAME to a range of cells in a row
Then I gave another Ref name Sizes to a range of cells in a columns

Now
if value in C15 found the same value in range [NAME] then get the
values from range [Sizes]

Guns Name: A | B | C | D
Sizes 1: 20 2 2 4
Sizes 2: 20 2 2 4
Sizes 3: 20 2 2 4


Now I want that to I put value A in a cell and it returns me all the
numbers available under it.
LIKE

A
20
20
20

Tnx in advance...
May be I m unable to clarify wht I want..but I hope it works...

Help required ....
 

Are you wanting it to return an array of values, or a single value? For a
single value, sounds like you want to use the LOOKUP or VLOOKUP function.
(explained clearly in XL help file)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


" wrote:

Need to know if a cell value equals to a value in a range of cells in
a row or column can I get the values under that matching cell..

For example...
I gave Ref name NAME to a range of cells in a row
Then I gave another Ref name Sizes to a range of cells in a columns

Now
if value in C15 found the same value in range [NAME] then get the
values from range [Sizes]

Guns Name: A | B | C | D
Sizes 1: 20 2 2 4
Sizes 2: 20 2 2 4
Sizes 3: 20 2 2 4


Now I want that to I put value A in a cell and it returns me all the
numbers available under it.
LIKE

A
20
20
20

Tnx in advance...
May be I m unable to clarify wht I want..but I hope it works...

Help required ....
 

Assuming that I understand your request correctly
A1 : D4 is your data table with header in the 1st row
place this formula in your target cell C15 and copy down 2 rows
and that your lookup value A is in cell E2.
Adjust to suit your range.


=HLOOKUP(E$2,$B$1:$D$4,2,0)

However. I don't understand this part of your request
" if value in C15 found the same value in range [NAME] then get the
values from range [Sizes] "

Does this do what you want?
--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









" wrote:

Need to know if a cell value equals to a value in a range of cells in
a row or column can I get the values under that matching cell..

For example...
I gave Ref name NAME to a range of cells in a row
Then I gave another Ref name Sizes to a range of cells in a columns

Now
if value in C15 found the same value in range [NAME] then get the
values from range [Sizes]

Guns Name: A | B | C | D
Sizes 1: 20 2 2 4
Sizes 2: 20 2 2 4
Sizes 3: 20 2 2 4


Now I want that to I put value A in a cell and it returns me all the
numbers available under it.
LIKE

A
20
20
20

Tnx in advance...
May be I m unable to clarify wht I want..but I hope it works...