About Us

Spencer101

Quote:

Originally Posted by Caveman1957

File Attached :) eventually

Main Data is in tab SS
In tab '7945 Users' I need to populate cells in green columns with data from SS tab if (in SS tab) ColumnC = 7945 and ColumnH = Yes

In tab '7945 NoVM' I need to populate cells in green columns with data from SS tab if (in SS tab) ColumnC = 7945 and ColumnH = No

Hope this is enough to get you started.

Thanks

Are you adverse to having a few hidden columns to do all the hard work for you?

Basically, there are two ways of doing this that I can think of. One involves some quite complex (and by that I mean awkward to maintain when data requirements change) formulas. The other involves some hidden "helper columns" that are nice and easy to maintain.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP DUPLICATE VALUES	Rj	Excel Worksheet Functions	3	February 17th 09 01:57 PM
Vlookup function returns duplicate values	Bigbelt	Excel Discussion (Misc queries)	5	December 18th 08 02:27 AM
Vlookup for multiple duplicate numerical values	pete8125	Excel Worksheet Functions	4	October 29th 08 02:49 AM
Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ?	Corey	Excel Programming	4	February 23rd 07 02:00 AM
problems with displaying "duplicate vlookup values" in same column	p CAST	Excel Discussion (Misc queries)	7	August 7th 06 06:24 PM

Menu

About Us