INSERTING NAME INTO TEXT

[chriskenny]

I have a spreadsheet that on one tab it has all the events and on another tab I have the name's of the DJ's

I would like to take the text from row 2 column C on the events tab and then put this in sheet 8 row 2 column E

In the text it says Toss on your bobbi socks & poodle skirts then head down to where DJ XXX will be spinning the tunes you want to hear!

Where it says DJ XXX I would like to insert the name of the DJ from sheet 8 row 2 column C

I have attached image of the sheets to hopefully help

If anyone could help me that would be a great help

Thank you in advance

 

[ashakantasharma]

You can use =VLOOKUP for get your data as required if there is no other conditions applied.

 

[chriskenny]

Sorry but excel is new to me, how would I do this