|
|
#2
05-20-2013, 10:09 PM
|
||||
|
||||
For E7, you could use an array formula input as:
=INDEX(Sheet1!$E$1:$E$100, MATCH(A7&B7&C7&D7, Sheet1!$A$1:$A$100 & Sheet1!$B$1:$B$100 & Sheet1!$C$1:$C$100 & Sheet1!$D$1:$D$100,0)) with Ctrl-Shift-Enter. However, you have also some work to do to make sure your dropdown selections exactly match the data on the Sheet1 (eg 'home care' is not 'homecare').
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Data Validation drop down
|
rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
| Forms -with validation | ubns | Excel | 1 | 05-04-2012 08:51 AM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
| Outlook userform validation help | aiwnjoo | Outlook | 0 | 12-08-2010 12:57 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode