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

HI,
I'm trying to set up a summary sheet which will bring up a client's details when i enter their name in a cell. I've attached a sample worksheet.

EG if I enter 'Post' in cell B2 in Summary worksheet, I want the data in the grey column to update with the relevant info from my Post spreadsheet.

Any idea's of how i may do this will be welcomed

Ky Van

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

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