Return a Cell Text

[kwaboy]

Hi, for example


a b c
1 John Wilson Darlington
2 Phil Hall Darlington
3 Sarah Davies Newcastle
4 Dave Stead Hartlepool
5 Julie Bowes Middlebrough
6 Michael Anderson Darlington

I would like in a seperate worksheet to look at cell c 1 and if it returns 'Darlington' then it fills the cell where the formula is with cells a and b

So cell a55(eg) would have the equation if cell c1 = Darlington return the value John Wilson
and then a56 if cell c2 = Darlington it returns the value Phil hall
in a57 if cell c3 = darlington then if it doesnt it returns blank,

Hope someone can help, if you can get me through this Im also hoping for further help

Thanks in advance

[jraj1106]

Hi

It will be a great help if you could explain the above in a sample excel file

[kwaboy]

Attached, thanks

[jraj1106]

Try this:

sample.xlsx

[kwaboy]

Thanks so much, perfect

Thanks

[kwaboy]

And now how do I display them in a list, excel sheet attached for more info

Thanks

[jraj1106]

One query: do you want the output in the same sheet or a different one? Using formula I m not sure how to avoid blanks lines frm appearing but I can help you with a macro and do the task as you wish...

So pls clear my query...

Check this out:

Test sheet.xlsm

[kwaboy]

Hi, it can have either same sheet or different one, it doesn't matter to me

Thanks

[kwaboy]

Tell you what I will start again, I get sent a spreadsheet like attached everyweek and I need it to display in the format as attached at the bottom as on power point, it doesn't have to be the exact font and size etc, but I do need the dat extracting to show similar, hope this makes sense and hope you can help

Thanks