Is it possible to use v look up to give more than one answer ie
each time the required number appears in a list then print each answer
and is it also possible to v look up one column of a list as above
(with multiple answers possible) and then do a vlook up on the
adjacent cell which could also provide multiple answers?

If so then please advise

Thanks
Choccieman

A vlookup will only return the value of the first matching record it finds in
a list.
In other words, when using a vlookup, your list needs to contain unique
values. If you are trying to sum some amount for several instances of a
given record then a SUMIF would work well for you.

A B C
123 $10.00
137 $10.00
123 $25.00
123 $15.00

123 (lookup value)

SUMIF($A$1:$A$4,$C$6,$B$1:$B$4) ...will give you a result of $50.00

" wrote:

Is it possible to use v look up to give more than one answer ie
each time the required number appears in a list then print each answer
and is it also possible to v look up one column of a list as above
(with multiple answers possible) and then do a vlook up on the
adjacent cell which could also provide multiple answers?

If so then please advise

Thanks
Choccieman