Hello everyone,
First time poster, using excel 2007 installed Mrexcel HTML maker, didnt appear in excel, forum tools addin was pasting extra data per the test forums. I am sorry in advance for doing this the hard way.
I have data in the DATA column, and I want to search whats in the LOOKUP STRING table and give the corresponding result from the table. Thankyou all in advance !
<tbody>
</tbody>
First time poster, using excel 2007 installed Mrexcel HTML maker, didnt appear in excel, forum tools addin was pasting extra data per the test forums. I am sorry in advance for doing this the hard way.
I have data in the DATA column, and I want to search whats in the LOOKUP STRING table and give the corresponding result from the table. Thankyou all in advance !
Data | Formula Result | ||||
Bananboat Cleaner 435353 | 2000 | ||||
Banaboat Cleaner 546456546 | 2000 | Lookup String | Result | ||
Cleaner 475464 | 2000 | Cleaner | 2000 | ||
Sydney Electricity 465464 | 3000 | Electricity | 3000 | ||
Melbourne Electricity 46546464 | 3000 | Fiacon | 4000 | ||
Electricity fjfh6765 | 3000 | Rent | 5000 | ||
576567 Electricity | 3000 | Fuji | 6000 | ||
Electricity | 3000 | Macquarie | 7000 | ||
Fiacon | 4000 | ||||
Flexirent | 5000 | ||||
Fuji Xerox fggdfgd55 | 6000 | ||||
hgfhf Fuji Xerox | 6000 | ||||
Macquarie 44498 | 7000 | ||||
999 Macquarie 987456 | 7000 |
<tbody>
</tbody>