=Vlookup("Type1",$A$2:$C$300,3,0))

--
regards,
Tom Ogilvy


Tom Atkisson wrote in message
...
I have a sheet with several columns.
A B C D E
1 Name Lvl Cost Retail Upgrade
2 Type1 1 5 10 0
3 Pear 1 6 12 0
4 Type2 2 12 24 5

If an upgrade is posible I link the cell under upgrade to the appropriate
product under cost (=C2). I sometimes add items to the bottom of the list
and then use the Sort to sort them by Lvl and then by Name. The problem
is
this does not change the upgrade links to what they are supposed to be
pointing to. Have tried it by just inserting a row and they seem to up
date
fine, but with sort it doesn't. Is there a fix to this?

Thanks in advance.