Weight Matching formula problem.

rarush

New Member
Joined
Sep 29, 2006
Messages
1
I am trying to create a spreadsheet that will allow me to enter pound and ounce values,
with the entry being assigned up to 5 sub entries.
For example:
Entry no. A22,B22,C22,D22,E22 then A23,B23,C23 and so on with each
having unique pound and ounce weights assigned to each entry no.,
there will be up to 150 entrys and when all are entered they will be matched according to actual weight,
but can not be matched into itself. Itself meaning the entry no. of the same numeric value.

Is VLOOKUP the answer? I would really appreciate any help offered on this issue.

Thanks
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
will it be possible for you to post a small extract and also what reply you want
 

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
rarush,

Another thing you may consider is using 150 rows of data instead of 150 columns. That is if you mean an entry uses a column starting with A22.

Don't forget to describe what you're trying to do as fully as possible so you can get the best advice instead of just trying to get a vlookup formula that may further complicate your ultimate goal.

Dufus
 

Forum statistics

Threads
1,141,226
Messages
5,705,130
Members
421,379
Latest member
SoundlessResonance

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
Top