Copying from several cells depending on the value of a seperate cell...

Hi,

im having some problems with a worksheet im making in excel, i will explain below what im trying to do..

I have a translation service, and we often deal with repeated phrases in our documents. We have these repetitions stored in a database (that has just over 2000 entries.)

The entries are stored in three columns chinese, english and pinyin and we would like when the phrase is typed in chinese excel automatically copies the relevant english and pinyin cells to the neighbouring cells... (hope it still makes sense.)

so if: 公报既定 chicken and peanuts GongBaoJiDing

when 公报既定 is typed in any cell (say B24) chicken and peanuts will be copied to C24 and GongBaoJiDing will be copied into D24.

If anyone could give me a hand with this it would be well appreciated. Ive been reading up on labels and naming cells, but ive not used excel for a long time and its giving me problems

thanks
Richard

hey sir,
can you attach a file to clarify more, i think what you want is easy to be done by vlookup and macros!!