Lookup a number, return a name

[bobbybrown]

Hi all,
I’m working on a simple sheet where I have a few columns. The important ones are:
A = first name
B = surname
F = points

On another sheet within the same workbook I am trying to get it to display any person who has 3 or more points.
I want it to display first name, surname and points if they have 3 or more points.
This sheet is a summary sheet if that makes sense.

I’ve tried with Vlookup but I just keep getting an error or a 0, so thought I should ask the experts for guidance.

Many thanks

 

[bobbybrown]

Also I’ve noticed in occasions of sickness it’s copying the store number, where it should be either points in E or sickness in F. Doesn’t matter which as both are the same.

 

[MARZIOTULLIO]

	B​	C​	D​
2​	Colleagues with 3 or more sickness within 6 months
3​
4​	First Name​	Surname​	Occasions of sickness​
5​	Name 4	Surname 4	3​
6​	Name 7	Surname 7	3​
7​	Name 11	Surname 11	3​
8​
9​
10​
11​
12​
13​
14​
15​

<tbody>
</tbody>

b5=IFERROR(INDEX('Sickness Tracker'!A$6:A$129,SMALL(IF('Sickness Tracker'!$F$6:$F$129>=3,ROW('Sickness Tracker'!A$6:A$129)-ROW('Sickness Tracker'!A$6)+1),ROWS('Sickness Tracker'!A$6:'Sickness Tracker'!A6))),"")

Control +shift +enter

copy across an down range b:c

D5=IFERROR(INDEX('Sickness Tracker'!$F$6:$F$129,MATCH('Summary of 3 in 6'!B5&'Summary of 3 in 6'!C5,'Sickness Tracker'!$A$6:$A$129&'Sickness Tracker'!$B$6:$B$129,0)),"")

copy down

 

[bobbybrown]

Perfect! Thankyou.