Multiple VLOOKUP's checking multiple Cells

OTPM · #1 05-04-2011, 06:06 AM

Hi
I have a question I need some help with. I want to create a formula that will check multiple cells against multiple Finish Dates in a spreadsheet. The formula I have to check the first cell is:
=IF(VLOOKUP(I11,A:F,6,FALSE)<TODAY(),"At Risk","On Time")

and this works fine but I would also like to check columns J to Z in the same formula. I am trying to avoid using VBA so that it can be used in the future by users who are not familiar with VBA.
Any help would be appreciated.
OTPM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
filling multiple cells whislt using Filter	VinceO	Excel	1	05-09-2011 06:38 AM
Multiple task lists and multiple calendars	kballing	Outlook	0	01-18-2011 10:23 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM
Set up multiple accounts or...	cabinfever1888	Outlook	2	08-28-2009 07:31 AM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM