Creating a table, from a list, with two variables

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]
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top