Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-22-2013, 02:47 PM
mark-gabb mark-gabb is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
mark-gabb is on a distinguished road
Default validation lookup with unique results


hi all i figure seeing as this is a different question and the last one was answered i better open a new one

i would like my lookup lists to return unique results only

as you can see from the example ill upload each columb after each will rteduce the available options to select. but it just doesnt seem to work that way


thanks for all your awesome help
Attached Files
File Type: xlsx cares%20work%20out%20sheet(1).xlsx (20.9 KB, 4 views)
Reply With Quote
  #2  
Old 05-22-2013, 06:11 PM
mark-gabb mark-gabb is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
mark-gabb is on a distinguished road
Default

ok so ive made a few changes sheet one represents the data i want to work with, im now using a seperate list to select company

so on the second sheet sheet i guess it has to be some kind of match formula so if a2:a100 = sgsc display b2:b100 that matches it, and so then one the 3rd one if a2:a100 and b2:200 match sgsc and personal care show days of week, that one isnt a huge deal
but times of day as we have two seperate companys that operate different times of day im struggling with
that and for b and d columb i cant work out either how to link both to seperate lists based on answer and how to remove the duplicates and only have one of each

as the services will be different as more companys are added
say 3rd company cgsc dont offer travel, so having a static seperate list for service wont work.....


please god help me
Attached Files
File Type: xlsx cares work out sheet.xlsx (22.8 KB, 2 views)
Reply With Quote
  #3  
Old 05-22-2013, 07:50 PM
mark-gabb mark-gabb is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2011
Posts: 17
mark-gabb is on a distinguished road
Default

ive created a new 2 columb group with company and times of daylisted out
as
sgsc 7-7
sgsc 7om-7am
sgsc allday
bcsc 7-10
bcsc 10-12

so now all i really need is something to lookup a7 which has the company and to tell it to display the list assosiated in the next colum with it
Reply With Quote
  #4  
Old 05-28-2013, 08:39 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 616
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

Hi, Mark. No one seems to be answering this, but when I looked at it I'm guessing that the reason is that no one else understands, either, what you're asking. I gather you have some data on one sheet and you want to look it up on the other sheet, but beyond that I'm not sure of your goal. Can you explain more clearly?

By the way, if you try adding part of the explanation in your native language, whatever that is, and if it happens to be one of the languages I can read, it may be clearer. Give it a try; it won't hurt anything if I can't read it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
multidependant validation and lookup mark-gabb Excel 4 05-21-2013 05:18 AM
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
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM
Search results disappearing Emerogork Office 3 07-17-2011 03:52 PM


All times are GMT -7. The time now is 08:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft