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...