Multiple VLOOKUP's checking multiple Cells

		Microsoft Office Forums > Microsoft Excel > Excel
Multiple VLOOKUP's checking multiple Cells

FAQ

Thread Tools

Display Modes

05-06-2011, 03:20 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Multiple VLOOKUP's checking multiple Cells

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

I * think * this native formula does what you want:

Code:

=IF(SUMPRODUCT(($A$2:$A$11=$I11:$Z11)*($F$2:$F$11<TODAY())),"At Risk","On Time")

It "looks up" the IDs listed in I11:Z11, finds them in column A and then counts how many of them have a finish date later than today. If any of them do, then it returns "At Risk".

Perhaps I misunderstood though.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 AM.