Hi,

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


[QUOTE=Dave Peterson]
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