In what way does it not work?
--
HTH
Bob Phillips
"Confused" wrote in message
...
Thank you very much for your help, but I am sorry this is not working.
"Bob Phillips" wrote:
Here is a formula that I think works, courtesy of Domenic. Put it in F4
and
copy across until you get a blank (no more)
=IF(COLUMN()-COLUMN($F4)+1<=COUNTIF(Sheet1!$G$2:$G$6,$B4),INDEX (Sheet1!$W$2:
$W$6,SMALL(IF(Sheet1!$G$2:$G$6=$B4,ROW(Sheet1!$G$2 :$G$6)-CELL("row",Sheet1!$
G$2)+1),COLUMN()-COLUMN($F4)+1)),"")
It is an array formula, so commit with Ctrl-Shift-Enter.
--
HTH
Bob Phillips
"Confused" wrote in message
...
I use "=VLOOKUP($B$4,Sheet1!$G$2:$W$137,17,FALSE)" to find cells in
column
"G" in "Sheet1" that contains the same value as in "B4" and return the
value
in column "W" in "Sheet1". My problem is that the numbers in column
"W"
are
unique but not the numbers in column "G".
In the next cell I want to do the same and also look for another cell
in
Column "G" in "Sheet1" with the same value as in "B4", but I will
always
get
the first found result. I want to look for the next cell in column "G"
in
"Sheet1" that contains the same value as in "B4" but with another
value in
Column "W" than the first found.
Is my question clear? Probably not, but I would very much appreciate
if
some
one could help me.
/Confused
|