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

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.

Discuss
0

Try this file

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

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: 1830) 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