Auto update /link up data with a change in cell value

Originally Posted by chinraj

Hi,
Put below formulas in B4,B5 and B6 respectively,
=IF($B$2="Post",AValue,"")
=IF(B2="Post",Areturn,"")
=IF(B2="Post",AvgTime,"")

Regards,
Chinraj

Thanks for the reply. But what I was really wanting to do is that if I change the client name then the data auto updates that clients profile. So let's say if I enter post in cell B2 it will bring up Post's info, if I enter Tomas in B2 it will bring up Tomas' info etc. I don't want to manually change the formula every time I change the client name.

If anyone can think of a way to do this it will be very much appreciated. Thanks