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

FormIdElement NameValue
63895784Name
63895784Phone No.
63895784Email Address
63895784IT Request TypeHardware
63895784Product/Service NameDell 2355dn Laser Printer
63895784Detailed Description of Product/ServiceFor Property
63895784Unit Price370
63895784Select an Agency:Dept of Corrections
63895784Agency IdentifierCAA
63895784Contact NameDiana Bleiker
63895784Phone719-269-5005
63895784Emaildiana.bleiker@doc.state.co.us
63895784Recipient of Product or ServiceDiana Bleiker
63895784Additional NameJeremiah Hansen
63895784Additional Names
63895784Waiver No.
63895784Project Type
63895784Project No.
63895784Project Start
63895784Project End
63895784Multi-Year
63895784Agreement Type
63895784Original PO/Contract No.
63895784Current FY Cost
63895784Total Cost
63895784Fiscal Year Start
63895784Fiscal Year End
63895784PO/Contract Start
63895784PO/Contract End
63895784Price Agreement No.
63892504NameLynn Padgett
63892504Phone No.970-626-4045
63892504Email Addresslynn@mtngeogeek.com
63892504IT Request TypeIT Service
63892504Product/Service NameCDSN Web-Map Utilities & AWQMS Enhancements
63892504Detailed Description of Product/ServiceGoogle-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.
63892504Unit Price32000
63892504Select an Agency:Dept of Public Health & Environment
63892504Agency Identifier
63892504Contact NameAimee Konowal
63892504Phone303-692-3530
63892504Emailamy.konowal@state.co.us
63892504Recipient of Product or ServiceMultiple users within the state of Colorado
63892504Additional Name
63892504Additional Names
63892504Waiver No.
63892504Project Type
63892504Project No.
63892504Project Start
63892504Project End
63892504Multi-Year
63892504Agreement Type
63892504Original PO/Contract No.
63892504Current FY Cost
63892504Total Cost
63892504Fiscal Year Start
63892504Fiscal Year End
63892504PO/Contract Start
63892504PO/Contract End
63892504Price Agreement No.

<colgroup><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

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