Formula to Find multiple values on table and place them in a cell.

Originally Posted by NBVC

It is unclear what you really want...

assuming you want this:

try in a new column row 2:

=O2&" "&K2&" "&G2&" "&Q2&" "&I2

copied down...

Sorry. I think I was just way to tired and frustrated last night.

I wish it were that easy.

What I need to do something with INDEX and MATCH I think.

If some wanted to help and maybe discuss what I need. I would be more than happy to give them a $50 gift certificate to our website (We sell Men's Apparel).

Originally Posted by NBVC

Try posting a sample showing what you have and what some expected results would look like.

I just uploaded a file showing an example of what I would love to see happen.

My head is about to explode if I try to work on it anymore.

I'm not sure if this will even work.

I'm very Hopeful! Thanks a lot for time and looking at this for me.

Brian

Originally Posted by NBVC

I am not sure where to start... I am a bit confused by your presentation. You've got a whole mix of things there. I am not sure that all you need is easily possible and that I can spare all the required time on it.

Perhaps we can take baby steps and see where we go... What is the first step you need done?

Thanks for looking!
I know! I wasn't kidding about my head ready to explode. It sucks I really would like this information.

Would you know how to get say all the chest information in one cell?
example for Chest:

(in one cell(Small: 19", Medium: 20", Large: 21", Xlarge, 22"))

I'm not sure if you do this, but would you be interested in maybe bartering/cash? For your services?

Originally Posted by NBVC

I am not really in this for the money.. I do it as a hobby and to help others... You can always donate to a charity if you feel so inclined.. I've got 2 listed in my signature.... but let's wait for that...

We can probably get it in one cell after first getting the info in various organized cells and then concatenating the information together.

I want to start with a clean slate and I am a visual person.. I like to see what I am aiming towards.... If you can show what you have and what exactly needs to be extracted in a fashion you want to see it in, then perhaps that is a start (show where the info came from). The attachment you had, showed to much stuff, and it was confusing....

I am off to bed soon, so won't probably be doing too much tonight (I am on Eastern Time).

Is there a formula to get the row's for multiple matching cell's?

a
1 X
2 X
3 X
4 Y


X=1:1 2:2 3:3

Thats the first part I think I need.

Thanks.
Should I be getting a value of 1?
I've tried the formula several times and I keep getting 1 in all cells I copy it too.

Sorry, I must not be all there today.

I put the X's in rows A2,A3,A4 and a Y in row A5.
I've tried putting the formula =SMALL(IF($A$2:$A$5="X",ROW($A$2:$A$5)-ROW($A$2)+1),COLUMNS($A$1:A$1))
I hold the CTRL and SHIFT keys down and press ENTER the formula is encased with the "{}"

I have put it in Cell's and get in each cell A1=1, A7-A19=1, B1-B11=2, C1-C10=3

I have know Idea what I'm doing wrong.
Sorry, I don't want to waste your time.

Originally Posted by NBVC

After you enter the formula in the first cell, hold the CTRL and SHIFT keys down and press ENTER.. You should see { } brackets appear around the formula.

Now copy it across horizontally.

Sorry! I didn't get it at first.

I don't think I can tackle this. Its way over my head.
I was wonder if you could refer me to someone who might be interested in this job for payment? I really would like to get this done as quickly as possible.

I uploaded the file.
I hope it explains what i would like to see done.

If you could let me know? I can try to post it the Commercial Exchange Services forum.


Thanks!

I do appreciate your help and input. Thank you.

If you have any colleagues that may be interested in my project please give them my posting.
http://www.excelforum.com/commercial...ml#post2460727

Thanks again!