Thread: Excel
View Single Post
  #5  
Old 03-12-2007, 10:25 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
=IF(VLOOKUP(P12,F6:G12,2,FALSE)>0,VLOOKUP(P12,F6:G 12,2,FALSE),"No entry here")

P12 = the company name
F6:G12 = the array that you are looking in
2 = the column number of that array that the dates are in
False = means they dont have to be in order

I just tried it in excel and it worked

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