Why is this VLOOKUP formula not working?

Hi everyone,

In this workbook, there is a Duty sheet where duties are given to persons on different dates. In next sheet I want to extract the names,designations and departments of the persons based on a date given in A2.

I used a VLOOKUP formula, please help me correct it.

See the file attached. (I am sorry that I used my language font in data field, but the column heading in English)

Attach File is not working So see this file link: https://onedrive.live.com/redir?resi...nt=file%2cxlsx

Thanks in Advance

Haque

Originally Posted by teylyn

Hello,

Vlookup tries to find the lookup value in the first column of the lookup range and returns a value from the columns to the right. Your formula is

=VLOOKUP(A2,Duty!$B$2:$G$21,2,FALSE)

So Vlookup takes the value in A2 and tries to find it in cells B2:B21 on the Duty sheet. That range does not have dates, but names. The date is not found, so the #N/A error shows in the cell.

Vlookup is clearly not working in this scenario.

Could you please try to explain what you would like to achieve? I see text that looks like dates in columns G to O, many values appear multiple times.

Please explain what the result should be on the "Date wise" sheet and what the logic is that leads to that result.

cheers, teylyn

Hi,
Thanks for your reply.

Actually, in the date wise sheet, I want that if put a date in A2, the name, designation and department names should be returned. For example, in the Duty sheet there are, say, 20 people but all of them are not assined duty on 20/4/16. I want only those people's details in the Date wise sheet.
I don't know which formula is applicable here. Please frame formulas of your choice for the desired result.
Regards
Haque