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
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,790
Messages
5,524,893
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top