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