Hi

I'm having a bit of a problem with a spreadsheet I'm working on. The
setup is I have two columns of strings and I need to put a different
string in a third column depending on the contents of the first two.
All this is on 1000+ rows.

However, there are many different strings, too many for an IF function,
and as the results depend on two columns, I don't think I can use a
VLOOKUP function.

The sheets come to me pre-done, and I need to keep the workings all on
a single sheet really.

Anyone get any ideas? it's stumped me for ages, and currently the only
way to do it is line by line... 1000+ rows per sheet? dozens of sheets?
I don't think so!

I'd really appreciate any help people can give me with this.

Thanks


--
Squeaker1066
------------------------------------------------------------------------
Squeaker1066's Profile: http://www.excelforum.com/member.php...o&userid=32667
View this thread: http://www.excelforum.com/showthread...hreadid=524734