Vlookup multiple same value

[empty_space]

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

[StephenR]

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

[empty_space]

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

[StephenR]

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.

[empty_space]

Many thanks this will help me move forward.

with my activities

empty_space

[Bjornar]

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:

=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$14 5)-ROW(A$2)+1),ROWS(X$7:X7))))