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
Bookmarks