using vlookup?

[static69]

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?

 

[jiwolf]

Yes. Vlookup is correct. see the help function.

 

[Alan Beban]

Yes. Vlookup is correct. see the help function.

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

 

[static69]

Great advice...thanks for the help...we'll see if i can get it to wor
no