Thread: multidependant validation and lookup
View Single Post
 
Old 05-20-2013, 10:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote