Please help!

[tammymb]

Hi! I posted once before but no one seems to know, My file is located at http://www.bluedaisypress.com/help.zip it only has 3 columns.

In column A are item numbers, column B - weights AND

column c are the item numbers I HAVE

column d is where I want to put the weights that match my item numbers from column a
I need them to stay in the order they are in though!

THEN when thats done, I need to convert the weights from pounds to grams!

SO basically, if you look at the item in lets say C2 - it is somewhere in column one with the right weight!

I would appreciate the help, Im lost!

Thank you!

 

[cyrilbrd]

Hi, can't access your file.
Better you post a small sample next time...
Given in A1:

Item#	Pounds	Item#_b	grams
x1	8.33	X2	2,281.57
x2	5.03	X4	1,719.12
x3	10.95	X5	657.71
x4	3.79	X7	4,445.21
x5	1.45
x6	8.44
x7	9.8
x8	3.13
x9	1.22
x10	4.46

<!--StartFragment--> <colgroup><col width="65" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

Formula in D2 is =CONVERT(INDEX($B$2:$B$11,MATCH(C2,$A$2:$A$11,0)),"lbm","g")