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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Colleagues with 3 or more sickness within 6 months[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

First Name​

[/TD]
[TD]

Surname​

[/TD]
[TD]

Occasions of sickness​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Name 4[/TD]
[TD]Surname 4[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]Name 7[/TD]
[TD]Surname 7[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]Name 11[/TD]
[TD]Surname 11[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.