Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |