Hello,
I'm trying to figure out how to write a formula that returns the last cell with a value in a column. I've looked all over the internet and I keep seeing this "LOOKUP(lookup_value, lookup_vector, [result_vector])" as an answer but it doesn't work for me. Also INDEX and MATCH all need something to reference off and doesn't work for me either, which is my issue with VLOOKUP. The sheet I'm making is a Dispatch time keeper for all of our drivers and throughout the day the drivers check-in with us. I have a master table that reports simple things at a glance but I want to add columns for Time, Initials, Stop # and ETA. So i need the info from Pic A to go to Pic B. Any idea will be welcome because I'm STUMPED. Thank you.
Pic A.JPG
Pic B.JPG
Bookmarks