| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
using vlookup?
i want to return several values from sheet1 based on the value of column A. If column a (say a1, a3,a5 are true at this time) has a true value, i want the 2, 3, and 15, (b,c,o) column of each true value to be displayed....... Is vlookup the proper function to use? if so what am i doing wrong, and if not what can i use and how? -- static69 ------------------------------------------------------------------------ static69's Profile: http://www.excelforum.com/member.php...o&userid=11075 View this thread: http://www.excelforum.com/showthread...hreadid=375285 |
|
#2
|
|||
|
|||
|
Yes. Vlookup is correct. see the help function.
"static69" wrote in message ... i want to return several values from sheet1 based on the value of column A. If column a (say a1, a3,a5 are true at this time) has a true value, i want the 2, 3, and 15, (b,c,o) column of each true value to be displayed....... Is vlookup the proper function to use? if so what am i doing wrong, and if not what can i use and how? -- static69 ------------------------------------------------------------------------ static69's Profile: http://www.excelforum.com/member.php...o&userid=11075 View this thread: http://www.excelforum.com/showthread...hreadid=375285 |
|
#3
|
|||
|
|||
|
jiwolf wrote:
Yes. Vlookup is correct. see the help function. "static69" wrote in message ... i want to return several values from sheet1 based on the value of column A. If column a (say a1, a3,a5 are true at this time) has a true value, i want the 2, 3, and 15, (b,c,o) column of each true value to be displayed....... Is vlookup the proper function to use? if so what am i doing wrong, and if not what can i use and how? -- static69 ------------------------------------------------------------------------ static69's Profile: http://www.excelforum.com/member.php...o&userid=11075 View this thread: http://www.excelforum.com/showthread...hreadid=375285 If the functions in the freely downloadable file at http:/home.pacbell.net/beban are available to your workbook you might want to consider something like =VLookups(True,A1:O5,{2,3,15}) array entered Alan Beban |
|
#4
|
|||
|
|||
|
Great advice...thanks for the help...we'll see if i can get it to work now -- static69 ------------------------------------------------------------------------ static69's Profile: http://www.excelforum.com/member.php...o&userid=11075 View this thread: http://www.excelforum.com/showthread...hreadid=375285 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| VLOOKUP not working | Excel Worksheet Functions | |||
Linear Mode
