Vlookup multiple same value

Hi all,

if possible i am after some guidance or direction with regards to the attached sheet. Basically i am looking for a product (which has the same value but different results)

could anyone help me achieve in understanding what i would require to achieve the example shown in the attached

yours humbly empty_space

Put this formula in X7 and drag across and down as far as possible. It's an array formula so must be entered by pressing Ctrl+Shift+Enter (curly brackets will appear round it):

=IF(COUNTIF($F$2:$F$145,$V$5)<ROWS(X$7:X7),"",INDEX(G$2:G$145,SMALL(IF($F$2:$F$145=$V$5,ROW(A$2:A$145)-ROW(A$2)+1),ROWS(X$7:X7))))

HI

thanks for the feedback, I have tried the information as you indicated and i get an error in formula. However i had this error message in other formulas i found from the other formulas. is it possible my excel is not working properly or some function is missing. any advice or guidance most appreicated

Empty_space

For some reason the forum is inserting spaces into the formula, there's space in INDEX and in the last 145.

Have a look at the attachment. I've hidden the zeros on the right using conditional formatting.

Many thanks this will help me move forward.

with my activities

empty_space

StephenR:

If you use the CODE wrapping tags around your formula, the forum will display your formula correct without spaces. Just select your formula and press the # button when you write your reply. The formula will appear like this:

Please Login or Register  to view this content.

Thanks Bjornar but for some reason it doesn't work for me. It's also been converted to lower case! I've had all sorts of problems with this site for a few days - database errors, connection reset, connection time out - so perhaps there's a problem at my end.

Please Login or Register  to view this content.

It's not only you which have the problems. It's the same with me. Keeps getting database errors, timeout etc. I think it started about a week ago.
If I write a long reply, I now have to copy the text to my clipboard before I submit, in case the system does not respond and I have to retype my answer.

Although I'm sorry you're experiencing the same problems, I'm glad it's not a problem at my end!

No doubt it will be resolved as soon as.