Searching for numbers and transferring data

[locarnos]

Hello.
Column F contains numbers and column G contains empty fields for descriptions.
Column C also contains numbers and Column D has descriptions.

I am looking for a way to find numbers in column F in column C, copy the corresponding descriptions from column D and put them in column G.

I have added a few descriptions in the G column manually. There's 1000 field and I can't do it manually.

[Fluff13]

Hi & welcome to the board.

how about

Please Login or Register  to view this content.

[locarnos]

"This formula is incorrect" Excel says


excelsays.JPG

[Fluff13]

You will probably need to change the commas to semi-colons, or whatever you system uses.