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