Hello,

I have two columns of data, names and numbers:

Tom 642
Ram 484
Matt 526

The numbers are linked with the names. I want to be able to have a cell, where I can put in the name and it will provide me their number.

I am currently using this for the two columns: =INDEX(O$#:O$#,MATCH(D#,P$#:P$#,0)) however I would like a code to allow me to do this if all of the data is on one line like this:

Tom, Ram, Matt, 642, 484, 526

So I still want excel to recognise the cell A1 (tom) is matched with the number in A4 (642).

Thanks,
Matt