g'morning everybody...

i don't know if you need a macro for this; maybe a simple function wil
do but i haven't been able to figure it out...

i have column R which contains model #s
i have column S which contains product descriptions (tv, audio, etc...
for the model # in column R

on the same worksheet i have BD through BX which is the prod. desc
again (so basically 21 products/columns)

what i was trying to figure out is if there's a way when i type th
prod. desc. in S, then it's corresponding R will appear in BD throug
BX...

example:

column R column S
tv123 TV
cd999 Audio
and so on...

BW is also TV now, and i'd like for the cell in R (tv123) to appea
under BW then i type in TV in S

i hope i explained well enough...
thanks in advance

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