1. I can't believe how fast you guys were.
2. I can't believe that can be replaced with "=INDIRECT("codes!B"&RIGHT(C3,2))"
I use Excel everyday but its for pretty straightforward stuff - I am always impressed by people that know how to really squeeze everything out of Excel. Amazing.
Thanks so much and now I am off to investigate two new commands.
Bookmarks