Hi,

Im BSLAUTOMATION but @ Home and cant reply to a thread because i forgot
my works password. Anyway


Dave Peterson Wrote:

Can you strip the unnecessary text out of the cell (remove "dinky " in
this
case)?

No because "Dinky" could be anything from a number or random text, see
below for more details

And do you have rules that can be applied in general--always take the
last two
words????

Not to sure at the moment but im trying to find a way and ill explain a
bit better of what im doing!

Eg

Sheet1 name = SORT (Main Page with formula in column B)

Sheet2 name = TOYS
Sheet2 A1 = "Toy Car"
Sheet2 A2 = "Toy Plane"

Sheet3 name = BABY
Sheet3 A1 = "Rattle"
Sheet3 A2 = "Blanket"

*plus 4 other Sheets i wish it to check (6 total)

MainPage with column A as the input
A1 = 1234 Toy Car Dinky B1 = TOYS
A2 = Plastic Rattle WL78 B2 = BABY
**A3 = Blanket with Toy Car B3 = TOYS & BABY


**This could be my only problem because there are 2 keywords on
different sheets

I think its going to need a macro as the Search formula is what im
after but i want to use a reference like (A1) instead of having to use
actual text or "keyword"

Can i change the reference or value of A1 and name it AA and then use
that in the formula or im i back to the macro??

Anyhelp please ?

Cheers

Craig


--
atxcomputers
------------------------------------------------------------------------
atxcomputers's Profile: http://www.excelforum.com/member.php...o&userid=26852
View this thread: http://www.excelforum.com/showthread...hreadid=400972