Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel General » Index, Match, and Transpose

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 01-31-2010, 10:12 AM
guynextdoor guynextdoor is offline
Registered User
  
Join Date: 31 Jan 2010
Location: Toronto, Canada
MS Office Version:Excel 2007
Posts: 8
guynextdoor is becoming part of the community
Index, Match, and Transpose

Please Register to Remove these Ads

Hello,
I am trying to design a spreadsheet and I have some difficulty getting it to work properly.

I want to be able to enter fund code in column A in "Report" worksheet, which will index and match to columns D and E in performance sheet, and will paste the transposed values from that column in the same order to the particular row in Report worksheet?

Can anyone please help!? I would really appreciate that. Thanks.
Attached Files
File Type: xlsx sample.xlsx (11.0 KB, 6 views)
Reply With Quote
  #2  
Old 01-31-2010, 10:26 AM
Richard Buttrey's Avatar
Richard Buttrey Richard Buttrey is offline
Forum Moderator
  
Join Date: 15 Feb 2008
Location: Grappenhall, UK
MS Office Version:Excel for Windows 2003, 2007, for Mac 2004, 2008
Posts: 3,351
Richard Buttrey is very confident of their ability Richard Buttrey is very confident of their ability Richard Buttrey is very confident of their ability
Re: Index and Match, and transpose HELP
Hi.

See attached.

Regards
Attached Files
File Type: xlsx sample.xlsx (14.5 KB, 4 views)
__________________
Richard Buttrey

If this was useful then please rate it appropriately.
Click the balance scales icon in the grey (or gray if you inhabit our former colony across the pond ) bar at the top of my post.
Last edited by Richard Buttrey; 01-31-2010 at 10:52 AM.
Reply With Quote
  #3  
Old 01-31-2010, 11:13 AM
guynextdoor guynextdoor is offline
Registered User
  
Join Date: 31 Jan 2010
Location: Toronto, Canada
MS Office Version:Excel 2007
Posts: 8
guynextdoor is becoming part of the community
Re: Index and Match, and transpose HELP
Quote:
Originally Posted by Richard Buttrey View Post
Hi.

See attached.

Regards
Richard,
Thank you! I really appreciate the time you took to answer my question.
Reply With Quote
  #4  
Old 01-31-2010, 11:30 AM
Richard Buttrey's Avatar
Richard Buttrey Richard Buttrey is offline
Forum Moderator
  
Join Date: 15 Feb 2008
Location: Grappenhall, UK
MS Office Version:Excel for Windows 2003, 2007, for Mac 2004, 2008
Posts: 3,351
Richard Buttrey is very confident of their ability Richard Buttrey is very confident of their ability Richard Buttrey is very confident of their ability
Re: Index and Match, and transpose HELP
Hi,

Thanks for that.

I'm pleased to have helped.

Regards
__________________
Richard Buttrey

If this was useful then please rate it appropriately.
Click the balance scales icon in the grey (or gray if you inhabit our former colony across the pond ) bar at the top of my post.
Reply With Quote
  #5  
Old 02-27-2010, 02:28 PM
guynextdoor guynextdoor is offline
Registered User
  
Join Date: 31 Jan 2010
Location: Toronto, Canada
MS Office Version:Excel 2007
Posts: 8
guynextdoor is becoming part of the community
Re: Index and Match, and transpose HELP
Hello excel experts,
I have another difficulty with the spreadsheet that Im trying to build.

I need to incorporate dynamic comments into the spreadsheet. That is when I select company name on the top (B1) it pulls the comments column from sheet Clients_funds. However, the difficulty is that these comments columns need to have some sort of friendly text editor interface so that people could easily change them monthly. Editing them in a single cell is quite problematic. Any ideas?

Also, specific to company in B1, there will be a risk marker (green, yellow, red). It has to be dynamic as well. I have no idea how to incorporate that into spreadshet. I'd appreciate any help.
Attached Files
File Type: xlsx sample1.xlsx (43.6 KB, 1 views)
Reply With Quote
  #6  
Old 02-27-2010, 04:58 PM
guynextdoor guynextdoor is offline
Registered User
  
Join Date: 31 Jan 2010
Location: Toronto, Canada
MS Office Version:Excel 2007
Posts: 8
guynextdoor is becoming part of the community
Re: Index and Match, and transpose HELP
Quote:
Originally Posted by guynextdoor View Post
Hello excel experts,
I have another difficulty with the spreadsheet that Im trying to build.

I need to incorporate dynamic comments into the spreadsheet. That is when I select company name on the top (B1) it pulls the comments column from sheet Clients_funds. However, the difficulty is that these comments columns need to have some sort of friendly text editor interface so that people could easily change them monthly. Editing them in a single cell is quite problematic. Any ideas?

Also, specific to company in B1, there will be a risk marker (green, yellow, red). It has to be dynamic as well. I have no idea how to incorporate that into spreadshet. I'd appreciate any help.
So, as for the second part with the risk marker, I have figured out I could do simple index/match with conditional format. However, I am clueless as for the first part with dynamic comments. I would really appreciate some ideas.
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top