Using InNDEX and Match

Hi & welcome to the board.
How about
=INDEX(C10:C14,AGGREGATE(15,6,(ROW(A10:A14)-ROW(A10)+1)/(A10:A14=B2)/(B10:B14=B3),1))

your a genius, thanks Guru, if for example there were two results saying place was portsmouth and country of residence was portsmouth but one said Buy and another said rent could this be displayed in another cell, i.e. get two results

How about
=FILTER(C10:C14,(A10:A14=B2)*(B10:B14=B3),"Nothing")

If i could get you a beer i would. Thank you

You're welcome & thanks for the feedback.

Morning Guru, tried using gthe filter option for my work excel and it says its not a valid function, is there another formula that would show several results.

realised our office uses excel 2016....sorry for the questions

How about
=IFERROR(INDEX($C$10:$C$14,AGGREGATE(15,6,(ROW($A$10:$A$14)-ROW($A$10)+1)/($A$10:$A$14=$B$2)/($B$10:$B$14=$B$3),ROWS(A$5:A5))),"")

Thanks for this. Sadly just returns 1 line which is the first match

In that case can you please supply a sample workbook?

Originally Posted by Fluff13

In that case can you please supply a sample workbook?

Please see attached i cant attach a workbook

If you read the yellow banner at the top of the site, it explains how to attach a workbook.
Have you copied the formula down to the next row?

Originally Posted by Fluff13

If you read the yellow banner at the top of the site, it explains how to attach a workbook.
Have you copied the formula down to the next row?

Morning please see the attached. If i add the formula to the next row it duplicates tbe first answer. Just wish my work would upgrade to 365 instead of office 2016.

It works for me
Excel 2016 (Windows) 32 bit

	A	B	C
1
2	Place	nigeria
3	Location	nigeria
4
5	Profiles	home
6		region
7		country
8
9	Place	Location	Info
10	Nigeria	Nigeria	home
11	Ukraine	Ukraine	away
12	Belarus	Ukraine	home and away
13	Nigeria	Nigeria	region
14	Egypt	France	country
15	Nigeria	Nigeria	country

Sheet: Sheet1

Do you have calculation set to automatic?