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