V Lookup Wrong info

[shaftdx]

Hello I have a problem with the Vlookup feature, Kinda...I figured it out how to get the information in there but it is grabbing the wrong Info. I will start off by explaining the kind of information I have going on here.

I work for a school bus company and we do alot of trips. I want to be able to click on the date of a trip and all the corresponding data for that trip will autofill in the trip sheet (Pick up location, destinations, the driver,times Ect.) and I got this to WORK! however I ran into a problem when there is more than one trip on the same day. For example lets say there are 5 trip going out on 9/14/18 ranging from B15 to B20 on the spread sheet. If I click on B15 the corresponding data will show up for B20. but it there is only one trip the next day and I put in B21 it works perfectly.

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #0057d6}</style>=VLOOKUP(B6,trips!$B$2:trips!$AE$2014,25,FALSE)
is the formula I am using

At first I thought it was just the dates that are the problem that it recognized one date as all dates in that section but I changed the lookup spot to something other than the date and the same thing happened

 

[Special-K99]

Your formula looks wrong, try this (untested)

=VLOOKUP(B6,trips!$B$2:$AE$2014,25,FALSE)

VLOOKUP will only return one result.

If you're looking to produce a list without blanks in the list you need a different formula.
If this is what you're after post some example data

Post a sample spreadsheet with cell references and expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[sandy666]

or use PowerQuery
it will show multiple result for single date