Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Help with Vlookup

0

Hi, 

I need support with a formula. i don't know if i should use Vlookup. see attached file and see if you can solve it? 

Thanks F

excel
MS Office Version: 2010
posted by: Fredrik860218 (rep: 2) on Thu Aug 11, 2016 at 8:49 am
Answer
Discuss

Answers

0

You can achieve the desired result using an array formula but I think the better thing to do here is to make the Sick Days section next to the calendar section and then select it all and go to the Data tab and click the Filter button. Then you can filter and sort the employee list however you like to view whatever you want.

Look at the attached example.

posted by: don (rep: 1989) on Thu Aug 11, 2016 at 11:30 am
Discuss
0

Try this file

posted by: salim_hasan (rep: 40) on Tue Aug 23, 2016 at 5:10 pm
Discuss
0

Hello,

I had applied vlookup to a file and saved the file.But,when I am opening the file today,there is an error #NV in those fields where the formula was applied.

Kindly help,

Thanks,

Regards,

Karthik

posted by: karthik91 on Mon Sep 11, 2017 at 9:46 am
Discuss

Discussion

How does your question relate to the thread you posted it in? Perhaps it should be a separate question so that you can get an answer?
Variatus (rep: 4889) Sep 11, '17 at 8:38 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login