Advanced lookup -Retrieving multiple data from a single cell?

Hi Martin, many thanks for your reply. I have previously used the lookup in the way you've shown but what I am striving for is some sort of function that I can fill down the whole of columns A and B so that literally all that needs to be done is to type the name into column C and the rest will appear straight away?

I mean I want to know if there's a way to just type in the name (i.e. "Example 1") and then as soon as I've typed that name, all the data will be laid out in a table next to where I've just typed the name. It's probably not possible without a macro though.

Originally Posted by martindwilson

if you are going to put a name in any random cell in that column and expect it to pop up then yes you'll need code
ok i rethought it and i thought of a possible way

that is fantastic! exactly what i needed. thank you so much for your help! I'll have a look at the code and try and decipher how you've done it.

sorry to be fussy but is there a way to get it to be blank in columns A and B rather than "#N/A" when there is text in C but it doesn't match anything in the data?

ok. thanks!