Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose with Match ?
Hi,
Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the name is changed on Sheet 2, B2, the correct data is transposed from Sheet 1. Thanks in advance for any help or insight on this. Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose with Match ?
Name in Sheet2!B2. Select F3:F33 in Sheet2. Enter the following array
formula: =TRANSPOSE(INDEX(Sheet1!C3:AH20,MATCH(B2,Sheet1!C3 :C20,0),0)) This is an array formula hence commit with Shift+Ctrl+Enter HTH Kostis Vezerides On Dec 4, 3:24*pm, Steve D wrote: Hi, Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the name is changed on Sheet 2, B2, the correct data is transposed from Sheet 1. Thanks in advance for any help or insight on this. *Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose with Match ?
Transpose is not needed
In F3 of Sheet2 enter =VLOOKUP($B$2,Sheet1!$C$3:$AH$20,ROW()-1,FALSE) Copy down the column best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Steve D" wrote in message ... Hi, Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the name is changed on Sheet 2, B2, the correct data is transposed from Sheet 1. Thanks in advance for any help or insight on this. Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose with Match ?
Thanks for the response, and formula.
"Bernard Liengme" wrote: Transpose is not needed In F3 of Sheet2 enter =VLOOKUP($B$2,Sheet1!$C$3:$AH$20,ROW()-1,FALSE) Copy down the column best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Steve D" wrote in message ... Hi, Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the name is changed on Sheet 2, B2, the correct data is transposed from Sheet 1. Thanks in advance for any help or insight on this. Steve |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose with Match ?
Great, thanks for the help.
"vezerid" wrote: Name in Sheet2!B2. Select F3:F33 in Sheet2. Enter the following array formula: =TRANSPOSE(INDEX(Sheet1!C3:AH20,MATCH(B2,Sheet1!C3 :C20,0),0)) This is an array formula hence commit with Shift+Ctrl+Enter HTH Kostis Vezerides On Dec 4, 3:24 pm, Steve D wrote: Hi, Was wondering if possible to use the Transpose function with another function. On Sheet 1, I have names in C3:C20, with data in each row of the names, from D3:AH20. What I want to do then, is on Sheet 2, B2, anyone of those names from Sheet 1 can be entered, then have the data from Sheet 1 on that row that matches the name entered, be transposed to F3:F33 on Sheet 2. So anytime the name is changed on Sheet 2, B2, the correct data is transposed from Sheet 1. Thanks in advance for any help or insight on this. Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to match 2 columns, if a match found add info from 2nd column | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions |