Nested IF Statement and VLookUp and Greater than

Hi, I have some data on people and the amount of holiday they've taken. I'm trying to create a vlookup which show's the names of those who have taken more than 12 days of holiday.

The fomula I'm using doesn't work, it just pulls out random names from the data set

=VLOOKUP(IF(H3>=15,"Reached 15 days",IF(H3=13,"2 days left",IF(H3<12,"Min 3 days"))),A3:A15,1,TRUE)

Thanks

Hi Mike,

Yes the original data is on a pivot table but i need to extrapolate this information onto another sheet. I need to be able to view on my dashboard those who are close to their total allotment for the year

Here is a sample of my data

Sample excel.PNG

I've admended the fomula to this:

=IF(GETPIVOTDATA("Total sick days",'Pivot Table data2'!$A3,"Employee","Alexander, Sam")>=5, 'Pivot Table data2'!A3,"")

However when i drag the formula it just pulls everyone's name rather than just those who have used up 5 or more holidays.

Thanks

Hi Mike,

Yes the original data is on a pivot table but i need to extrapolate this information onto another sheet. I need to be able to view on my dashboard those who are close to their total allotment for the year

I've attached a screenshot of a sample of my data

Sample excel.PNG

I've admended the fomula to this:

=IF(GETPIVOTDATA("Total sick days",'Pivot Table data2'!$A3,"Employee","Alexander, Sam")>=5, 'Pivot Table data2'!A3,"")

However when i drag the formula it just pulls everyone's name rather than just those who have used up 5 or more holidays.