vlookup function return all values
This formula works perfect, but because I have so much data I'd like to have
the keys in more columns than more rows. How can I search both colums and
return the information in the column beside it?
ID Value ID Value
1 1.2 2 1.3
1 1.6 2 1.7
3 1.4 4 1.5
So if I'm searching for ID 2 it will return 1.3 and 1.7. The main help i
need is with returning the value in the 4th column.
"Domenic" wrote:
In that case, the formula would change as follows...
=IF(ROWS(E$1:E1)<=COUNTIF(Sheet2!$A$1:$A$27,$D$1), INDEX(Sheet2!B$1:B$27,S
MALL(IF(Sheet2!$A$1:$A$27=$D$1,ROW(Sheet2!$B$1:$B$ 27)-ROW(Sheet2!$B$1)+1)
,ROWS(E$1:E1))),"")
In article ,
j2thea wrote:
That was extremely helpful. One more question. Would I just type Sheet2!
before each cell reference if the data is on sheet two and the formula is on
sheet one?
|