Searching for a common number with a vlookup

[Graham C1600]

Hi,

I've been using a Vlookup for a while now and it has worked really well so far and given men the results I expect. However the data in the column of the Vlookup range has now changed slightly and i'm needing to find the most common number from the column. The data looks a little like below.[TABLE="width: 200"]
<tbody>[TR]
[TD="align: center"]Batch 60[/TD]
[TD="align: center"]05/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]Batch 61[/TD]
[TD="align: center"]07/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]Batch 62[/TD]
[TD="align: center"]07/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]Batch 63[/TD]
[TD="align: center"]07/04/2018[/TD]
[/TR]
</tbody>[/TABLE]

On another tab i also have the first column data as above so Batch 60 through to 63. I have a field on this tab where i have been pulling the date from the above tab into this tab using a simple vlookup. The data in the second column as above is now starting to change and i am getting mixed dates thrown at me but i only need to capture the most common date. If i now use the vlookup it returns the date in the top box. How can i use a vlookup to find the most common data in the column ?

Any ideas ?

Many thanks

 

[baitmaster]

You don't want to use VLOOKUP for this. In fact, you don't want to use VLOOKUP ever, for anything...

If you want to find the most common date then you can use =MODE.SNGL(list of dates) because dates are numbers

If you want to find corresponding values in lists, then instead of =VLOOKUP (lookup value, array, column, false) use =INDEX(values column in array, MATCH(lookup value, lookup column in array, 0))