Access with formulas and fetch values

rsingh4377

New Member
Joined
Jun 26, 2019
Messages
1
[TABLE="width: 500"]
<tbody>[TR]
[TD]BIN
[/TD]
[TD]ELEMENT#
[/TD]
[TD]TTL
[/TD]
[TD]LV2
[/TD]
[TD]LV3
[/TD]
[TD]LV4
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]12
[/TD]
[TD]200
[/TD]
[TD]150
[/TD]
[TD]50
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]13
[/TD]
[TD]150
[/TD]
[TD]130
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]15
[/TD]
[TD]350
[/TD]
[TD]350
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]18
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]201
[/TD]
[TD]255
[/TD]
[TD]255
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]340
[/TD]
[TD]30
[/TD]
[TD]25
[/TD]
[TD][/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Secondarytable ^
main tbl ex. below[TABLE="width: 500"]
<tbody>[TR]
[TD]BIN
[/TD]
[TD]ELEMENT X 0-100
[/TD]
[TD]ELEMENT Y100-200

[/TD]
[TD]ELEMENT Z 200-400
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]9.86
[/TD]
[TD][/TD]
[TD]1.75
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1235
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1236
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1237
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1238
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1239
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1240
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Hi, I am attempting to create a formula in excel in which Ican perform a simple mathematical operation by picking through certain criteriafrom data on another sheet. However, there are duplicate entries on the sheetfrom which I need to reference. For example, I have a main excel sheet where Ihave several columns set up to display a percentage of each element of a bridge’sconstruction with each row being referenced to with a BIN number. I am tryingto pull data from a secondary sheet in which the element number is in its owncolumn resulting in multiple rows with the same BIN number. Further on the secondarysheet is the data in which I need to extract a calculation in which I find thepercentage makeup of levels 3 and 4 from the entire sq ft of the element. However,there are multiple element’s numbers included in one element group, thereforethere can be several entries for each element group in addition to severalentries for other element groups. For example, say from a list of 20,000entries on the secondary table, I am searching only for BIN number 1234 forelement x and the element numbers associated with this element group are 5, 6and 7. In an equation, I need to find a way to 1) find BIN number 1234 2) find specificallyelments 5, 6 and 7 while accounting for the fact that there may not be any datafor these elements 3) find the sum of the total sq ft (which would be in itsown column) and find the sum of levels 3 and 4 (which are also in their owncolumns respectively) and perform a calculation with this data. PLEASE HELP!




 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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