Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Lookup all occurences and return their column headings
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by grantt View Post
Hi all

Please see the attached.

I am trying to use the value in column G to find which columns on that row contain this value. I then want to list the column headings for each column which contain that value. So far I have something working that lists the first column heading, but I need to list all column headings, ideally in a single cell separated by commas.

Note that some cells contain the lookup letter, in addition to another letter. These must not be included in the above formula. I also need a way to list the column headings of these guys (which contain 2 letters, one of which is in column G) in a separate cell.

Please help.

Thanks.
No one able to take a crack at this?
Reply With QuoteReply With Quote
  #2   Report Post  
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by grantt View Post
No one able to take a crack at this?
I think 4 hours is slightly short a time to be giving this a bump.
Give people a chance!
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 1,045
Default Lookup all occurences and return their column headings
On Thu, 13 Sep 2012 20:30:00 +0000, grantt wrote:

No one able to take a crack at this?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+


Perhaps if you indicate the problem with my posted answer, someone might be able to add a suggestion.
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Select minimum with duplicate values to return column headings Bobblebee Excel Worksheet Functions 3 April 3rd 12 04:44 AM
Lookup column headings? RunsWithKnives Excel Discussion (Misc queries) 5 December 8th 07 10:40 AM
LOOKUP and return the column heading for IF/THEN return for False NN Excel Discussion (Misc queries) 1 October 6th 06 11:24 AM
Lookup a row and column and return value Carim Excel Worksheet Functions 2 September 25th 06 04:38 PM
lookup from one column return value from another? Maria Excel Discussion (Misc queries) 1 April 1st 05 05:57 AM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement