whalenmich
New Member
- Joined
- Jul 20, 2012
- Messages
- 2
So here is the challange....
Below is a portion of the table I am using. FormID is a number that duplicated for each of the unique Element Names. There are 30 different fields that the Element names could be (name, phone No, etc). If you start NEW WORKSHEET and create a table (FormID in the rows, and Element names in the headers across the columns; how would you carry over the Value that is respective.
So for instance if 63895784 is in cell A2 in the table and IT Request type is in cell E1; what formula would you run to return hardware?
Many thanks!
whalenmich
[TABLE="width: 1014"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]FormId[/TD]
[TD]Element Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Phone No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Email Address[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]IT Request Type[/TD]
[TD]Hardware[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Product/Service Name[/TD]
[TD]Dell 2355dn Laser Printer[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Detailed Description of Product/Service[/TD]
[TD]For Property[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Unit Price[/TD]
[TD]370[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Select an Agency:[/TD]
[TD]Dept of Corrections[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Agency Identifier[/TD]
[TD]CAA[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Contact Name[/TD]
[TD]Diana Bleiker[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Phone[/TD]
[TD]719-269-5005[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Email[/TD]
[TD]diana.bleiker@doc.state.co.us[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Recipient of Product or Service[/TD]
[TD]Diana Bleiker[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Additional Name[/TD]
[TD]Jeremiah Hansen[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Additional Names[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Waiver No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Multi-Year[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Agreement Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Original PO/Contract No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Current FY Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Total Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Fiscal Year Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Fiscal Year End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]PO/Contract Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]PO/Contract End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Price Agreement No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Name[/TD]
[TD]Lynn Padgett[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Phone No.[/TD]
[TD]970-626-4045[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Email Address[/TD]
[TD]lynn@mtngeogeek.com[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]IT Request Type[/TD]
[TD]IT Service[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Product/Service Name[/TD]
[TD]CDSN Web-Map Utilities & AWQMS Enhancements[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Detailed Description of Product/Service[/TD]
[TD]Google-Map Utility to show monitoring locations and associated water quality data in the Ambient Water Quality Monitoring System (AWQMS) database to multiple users within the state of Colorado.[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Unit Price[/TD]
[TD]32000[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Select an Agency:[/TD]
[TD]Dept of Public Health & Environment[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Agency Identifier[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Contact Name[/TD]
[TD]Aimee Konowal[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Phone[/TD]
[TD]303-692-3530[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Email[/TD]
[TD]amy.konowal@state.co.us[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Recipient of Product or Service[/TD]
[TD]Multiple users within the state of Colorado[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Additional Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Additional Names[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Waiver No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Multi-Year[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Agreement Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Original PO/Contract No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Current FY Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Total Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Fiscal Year Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Fiscal Year End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]PO/Contract Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]PO/Contract End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Price Agreement No.[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Below is a portion of the table I am using. FormID is a number that duplicated for each of the unique Element Names. There are 30 different fields that the Element names could be (name, phone No, etc). If you start NEW WORKSHEET and create a table (FormID in the rows, and Element names in the headers across the columns; how would you carry over the Value that is respective.
So for instance if 63895784 is in cell A2 in the table and IT Request type is in cell E1; what formula would you run to return hardware?
Many thanks!
whalenmich
[TABLE="width: 1014"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]FormId[/TD]
[TD]Element Name[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Phone No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Email Address[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]IT Request Type[/TD]
[TD]Hardware[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Product/Service Name[/TD]
[TD]Dell 2355dn Laser Printer[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Detailed Description of Product/Service[/TD]
[TD]For Property[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Unit Price[/TD]
[TD]370[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Select an Agency:[/TD]
[TD]Dept of Corrections[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Agency Identifier[/TD]
[TD]CAA[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Contact Name[/TD]
[TD]Diana Bleiker[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Phone[/TD]
[TD]719-269-5005[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Email[/TD]
[TD]diana.bleiker@doc.state.co.us[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Recipient of Product or Service[/TD]
[TD]Diana Bleiker[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Additional Name[/TD]
[TD]Jeremiah Hansen[/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Additional Names[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Waiver No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Project End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Multi-Year[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Agreement Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Original PO/Contract No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Current FY Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Total Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Fiscal Year Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Fiscal Year End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]PO/Contract Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]PO/Contract End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63895784[/TD]
[TD]Price Agreement No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Name[/TD]
[TD]Lynn Padgett[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Phone No.[/TD]
[TD]970-626-4045[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Email Address[/TD]
[TD]lynn@mtngeogeek.com[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]IT Request Type[/TD]
[TD]IT Service[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Product/Service Name[/TD]
[TD]CDSN Web-Map Utilities & AWQMS Enhancements[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Detailed Description of Product/Service[/TD]
[TD]Google-Map Utility to show monitoring locations and associated water quality data in the Ambient Water Quality Monitoring System (AWQMS) database to multiple users within the state of Colorado.[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Unit Price[/TD]
[TD]32000[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Select an Agency:[/TD]
[TD]Dept of Public Health & Environment[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Agency Identifier[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Contact Name[/TD]
[TD]Aimee Konowal[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Phone[/TD]
[TD]303-692-3530[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Email[/TD]
[TD]amy.konowal@state.co.us[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Recipient of Product or Service[/TD]
[TD]Multiple users within the state of Colorado[/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Additional Name[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Additional Names[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Waiver No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Project End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Multi-Year[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Agreement Type[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Original PO/Contract No.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Current FY Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Total Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Fiscal Year Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Fiscal Year End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]PO/Contract Start[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]PO/Contract End[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]63892504[/TD]
[TD]Price Agreement No.[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]