Find value in column, and display ajacent cell

Hey Everyone,

** Edit ** Accidentally deleted first half of title, should read "Find value in column, and display ajacent cell"

I've been going insane trying to get excel to do what I want; a brief explanation...

Working on delivery sheets that have a list of customers that we service in column "C", and the types of products we deliver to them in column "G".

What I'm trying to accomplish is creating a "build sheet" on a separate spreadsheet for our plant workers that will update automatically when the run sheets are updated.

On to the issue; some of our customers own their own product, and in column "G", the term "C.O.G." is placed.
What I need to happen; Any time the value "C.O.G." occurs on a run sheet, I need the route build to display the customer name from column "C".

Here's a sample attached;

Any help would be much appreciated.

Thanks,

-Chris

Just use a VLOOKUP formula.

Formula:

Please Login or Register  to view this content.

VLOOKUP values only need to be arraigned in order if you are not looking for an exact match. If you add the "FALSE" argument as Leon did, then Excel will look through all data until it finds an exact match.

Does that help?

See if this is what you had in mind:

http://www.excelforum.com/tips-and-t...ml#post3376007

if you need multiple results use a countif on "*C.O.G.*" and a VLOOKUPNTH with the Nths being 1 to count. (you can google VLOOKUPNTH UDF)

Originally Posted by Tony Valko

See if this is what you had in mind:

http://www.excelforum.com/tips-and-t...ml#post3376007

Promising... However, the formula only generates the first customer with the "C.O.G." value.

Good deal. Thanks for the feedback!

If your question has been answered please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools>Mark this thread as solved.