Is it possible to analyse text in Excel in cells in a column and use true/false outcomes to select a value from a vector (or column as I suppose you experts call it) and to output that value to a different cell ? eg A1 has text value green, B1 has numerical value n1, C1 acquires value n1 from B1, D1 acquires value 0 or blank; A2 has text value blue, B2 has value n2, C2 acquires 0 or blank, D2 acquires value n2 from B2; A3 has text value green. B3 has value n3, C3 acquires value n3 from B3, D3 acquires value zero or blank; ... Sorry I tried to lay this out as a table, but the forum text editor didn't like it - great for a forum on Excel, eh? Anyway I hope this makes sense and that there is a nice simple solution that I've just overlooked. Thanks, Andrew