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?