Thread: Excel
View Single Post
  #4  
Old 03-12-2007, 10:10 PM
Chris's Avatar
Chris Chris is offline
WRX Hi Five Club
Member
 
Join Date: May 2007
Location: Perth
Posts: 237
Thanks: 0
Thanked 0 Times in 0 Posts
Chris at standard level
Default

Quote:
Originally Posted by Master D
then use it in an if statement

=IF(Column C>0,vlookup(company name cell,the whole array on the other sheet that you want to choose from, the column number of this array that you want to look in,'false'),'insert message here')



And you kiss your mother with that mouth!?!?!?!?!?!
Haha well unless you have any suggestions? thats the best I can do without actually opening excel to test it. Note the second edit. That one might have more of a chance

By the way when i said "column C" i mean select that cell in column C. but then I realised that the whole statement probably wouldnt work so i changed it.

Last edited by Chris; 03-12-2007 at 10:13 PM.
Reply With Quote