Access with formulas and fetch values

[rsingh4377]

[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!