Hi Everyone...

Here is what I am trying to do...be patient...it's long.

I have columns lets say A,B,C,D

In column "A" I want to input a name and have it pull all the
related products that go into it into column "c".

Then I want to enter and amount in grams say 101.5 in column "B" and
have it show up in column "D" plus 10%. For each of the related
products
that showed up for column "A:

Hope that explains things good enough !

Thanks again for the help !.


--
f_disk
------------------------------------------------------------------------
f_disk's Profile: http://www.excelforum.com/member.php...o&userid=36325
View this thread: http://www.excelforum.com/showthread...hreadid=561071

f_disk wrote:
Hi Everyone...

Here is what I am trying to do...be patient...it's long.

I have columns lets say A,B,C,D

In column "A" I want to input a name and have it pull all the
related products that go into it into column "c".

Then I want to enter and amount in grams say 101.5 in column "B" and
have it show up in column "D" plus 10%. For each of the related
products
that showed up for column "A:

Hope that explains things good enough !

Thanks again for the help !.


Sorry, but I think I don't understand...

maybe you could upload a small example file to www.savefile.com

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

I have posted a txt file with information and hopefully a good example
of what I am trying to do.

http://www.savefile.com/files2.php?f...029&key=526095


--
f_disk
------------------------------------------------------------------------
f_disk's Profile: http://www.excelforum.com/member.php...o&userid=36325
View this thread: http://www.excelforum.com/showthread...hreadid=561071

See the above post...thanks


--
f_disk
------------------------------------------------------------------------
f_disk's Profile: http://www.excelforum.com/member.php...o&userid=36325
View this thread: http://www.excelforum.com/showthread...hreadid=561071

f_disk wrote:
I have posted a txt file with information and hopefully a good example
of what I am trying to do.

http://www.savefile.com/files2.php?f...029&key=526095


I'm sorry...

I tried with different kind of formulas, using INDEX + MATCH, OFFSET, etc,
but I didn't succeed.

Maybe with some VBA it would be very simple, but not for me...

--
Sorry I can't help you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy