need help in generating formula by extracting text and then looking up the value both present in a single cell

zaks81

New Member
Joined
Jan 6, 2014
Messages
1
I have a column as named particulars below and my requirements are in columns ahead...plz someone can give me a solution.. Would be grateful…thanks in advance.


[TABLE="width: 630"]
<tbody>[TR]
[TD="bgcolor: transparent"] Particulars
[/TD]
[TD="width: 147, bgcolor: transparent"] Look up fields from
the column 1
[/TD]
[TD="width: 96, bgcolor: transparent"] End result required for individual look up field
[/TD]
[TD="width: 102, bgcolor: transparent"] End result required for individual look up field
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] SWL 3.70 MT. @ 255 PMT. OCC 20.08 MT. @ 180 PMT. AS D/O NO.3499 W/SLIP NO. 205888/205890 DTD 01/01/13
[/TD]
[TD="width: 147, bgcolor: transparent"] SWL & OCC
[/TD]
[TD="width: 96, bgcolor: transparent"]
3.7
[/TD]
[TD="width: 102, bgcolor: transparent"]
20.08
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] OCC 18.04 MT. @ $ 180 PMT. SWL 5.29 MT. @ $ 255 PMT. AS D/O NO.3500 W/SLIP NO.205957/205960 DTD 02/01/13
[/TD]
[TD="width: 147, bgcolor: transparent"] OCC & SWL
[/TD]
[TD="width: 96, bgcolor: transparent"]
18.04
[/TD]
[TD="width: 102, bgcolor: transparent"]
5.29
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] OINP 27.65 MT. @ 678.95 PMT. ( JAN-PUR) W/SLIP NO.530880 & UNIBRASS INV# 12218/2012
[/TD]
[TD="width: 147, bgcolor: transparent"] OINP
[/TD]
[TD="width: 96, bgcolor: transparent"]
27.65
[/TD]
[TD="width: 102, bgcolor: transparent"]
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] OCC 75.33 MT. @ 543.34 PMT. OINP 6.779 MT. @ 580.32 PMT. POC 2.897 MT. @ 500.51 PMT. SWL 3.694 MT. @ 700.05 PMT. MIX 0.33 MT. @ 500 PMT. MIX/WST 1.06 MT. @ 321.69 PMT. OFF/WST 0.80 MT@ 500 PMT.-001
[/TD]
[TD="width: 147, bgcolor: transparent"] OCC, OINP, POC,
SWL, MIX, MIX/WST,
OFF/WST
[/TD]
[TD="width: 96, bgcolor: transparent"]
75.33
[/TD]
[TD="width: 102, bgcolor: transparent"]
6.779
[/TD]
[TD="width: 66, bgcolor: transparent"]
2.897
[/TD]
[TD="width: 48, bgcolor: transparent"]
3.694
[/TD]
[TD="width: 48, bgcolor: transparent"] etc…
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"] OCC 20.530 MT. @ 180 PMT. AS D/O NO. 5301 AS W/SLIP NO. 206000 DTD 03/01/13
[/TD]
[TD="width: 147, bgcolor: transparent"] OCC
[/TD]
[TD="width: 96, bgcolor: transparent"]
20.53
[/TD]
[TD="width: 102, bgcolor: transparent"]
[/TD]
[TD="width: 66, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[TD="width: 48, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
 

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