On 5 Aug, 20:25, Eric D wrote:
is it possible to have an if statement or something that could return true
values in a list? ex. on a separate tab i have a sheet that has 2 columns in
column 1 is names and in column 2 is $$. *Is there a formula i can enter on a
separate sheet so that it gives the answer but without spaces.

spreadsheet 1 * * * * * * * * * * * * * * * spreadsheet 2
* * * * * * * * * * * * * * * * * * * * * * * * * * * desired result
col1 * * * *col2 * * * * * * * * * * * * * * *col1 * * * * col2
eric * * * * *20 * * * * * * * * * * * * * * *eric * * * * * *20
dave * * * * 0 * * * * * * * * * * * * * * * clark * * * * * 10
clark * * * *10 * * * * * * * * * * * * * * * mike * * * * * *5
lori * * * * * *0
stan * * * * *0
mike * * * * *5

any thoughts?
--
Eric

seel vlookup in help