Vlookup
 

Hi,
When I run a Vlookup for 'X' on a list which has many 'X' values, Excel
only returns the bottom value in the result. Is it possible to return
the Sum of the Xs?
Also, is it possible to make the Vlookup return multiple columns
instead of just one?

Thanks


--
sanders
------------------------------------------------------------------------
sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
View this thread: http://www.excelforum.com/showthread...hreadid=567367

Vlookup
 

Try:

=COUNTIF(A:A,"X") to give count of Xs

=SUMIF(A1;A100,"X",B1:B100) will sum values in column B where Column A = "X"


=VLOOKUP(3,A1:G8,{2,5,6}), array entered (Ctrl+Shift+Enter) into a 3-cell
row will return
the values from Columns B,E & F that correspond to the value of 3 in Column A.

=VLOOKUP(3,A1:G8,{2;5;6}) will return them to a 3-cell column (array entered).

HTH

"sanders" wrote:


Hi,
When I run a Vlookup for 'X' on a list which has many 'X' values, Excel
only returns the bottom value in the result. Is it possible to return
the Sum of the Xs?
Also, is it possible to make the Vlookup return multiple columns
instead of just one?

Thanks


--
sanders
------------------------------------------------------------------------
sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
View this thread: http://www.excelforum.com/showthread...hreadid=567367