Conditional Formatting Help!
Hello--I am trying to develop a quick route sheet. Basically, I want say, "If you reside on A Street, your collection day is Monday." Or, "If you reside on B Street, your collection day is Tuesday."
I want to list a street in one column and a corresponding column would list Monday-Friday depending on what street it is. Does that make sense?
Here's how I'd like the finished product to look:
Your Address: 1001 A St. Your Collection Day: Monday
That way, I can just enter a street name, and the correct collection day will show up without me having to research and type in each one.
Any help would be appreciated!
Thank you....
Hi Dani;
This can be done using the Vlookup function. I'd be able to assist you with this if you could provide an example workbook with an small sample of scrambled / anonymous data.
It would require a separate table with the streets and their collection days, and it would be easiest if the user/house listing to have the street name separate from the house # on the street
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
Thank you for your response!
I've attached a tiny sample of what i'm talking about. The first sheet would have the collection information for each street. The second sheet would contain information to be sent to the customer of record. When I enter a street name into C4, I want the corresponding collection day to be entered in C7.
Any help would be so great!
Thank you, Danielle
This would do it:
VLOOKUP(C4,'Coll Days'!A:C,3,FALSE)
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Thanks Ron!! This will sound really stupid (I'm Excel illiterate), but would I type that entire thing: VLOOKUP(C4,'Coll Days'!A:C,3,FALSE) into the C7? Or which column?
Nevermind! I got it....thank you so much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks