at first it didn't seem to work but now it does :))

is there a way I can refer to a seporate worksheet though?

=VLOOKUP(lookupworksheet($A1),locations,2,FALSE)

or something?

Thank you so much for your help!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/