help in my project

  • Thread starter Thread starter nader
  • Start date Start date
N

nader

this is a big question and hope I'll find a help

I enter in the cell B1 sheet1 the name of the material
and in the cells from B2 to B10 the prices

my question
so if I'll enter the name of the material(B1) in the cell A1 sheet2
it will show all the prices of B2 to B10 in the cells A2 to A10
so what is the code for that?
 
nader said:
this is a big question and hope I'll find a help

I enter in the cell B1 sheet1 the name of the material
and in the cells from B2 to B10 the prices

my question
so if I'll enter the name of the material(B1) in the cell A1 sheet2
it will show all the prices of B2 to B10 in the cells A2 to A10
so what is the code for that?
Click to expand...

Try this ...

Enter in Cell A2 of Sheet 2.

=IF($A$1=SHEET1!$B$1,SHEET1!B2,\"\")

and copy down until Cell A10.

Hope this is what you need.

Regards.
 
it's wonderful from you mr BenjieLop
but may be I was not so clear with you
I want to print the content of cells from b1 to b1000 , without ente
the code in all the cells one by one

by the way I'm new in useing functio
 
Hi

Try entering in cell A2 of Sheet2
=HLOOKUP(A1,Sheet1!$B$1:$B$10,row(),0)
and copy down as far as you need.

Regards

Roger Govier
 
May be a bit Off Topic but I have noticed several posts with \"\" in which I
assume the backslashes are saying "The next character is a literal
character"

As this retuns a "The formula you types contains an error" and then
highlights the \"\" in XL 97 may I ask anyone what version that combination
is required for or is it a factor of Excelforum posting?

--
Regards

Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
It's a by product of posting through ExcelForum. I don't know if it's some
escape character or just an HTML interpretation.

I guess those who post through excelforum can format their posts--colors and
bolding. The bold shows up as an asterisk (*). I thought it was a problem with
sample data until someone set me straight.
 
Thank you Dave, I had noticed the asterisks as well and I had read
somewhere in a post that it signified bold text. I thought however that I
was seeing the asterisks as a consequence of me reading the posts in plain
text and that in Ritch Text I would have seen the Bold text but not the
asterisks but obviously not.

--
Regards,


Sandy
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top