Jan 27 2019 11:57 AM
Jan 27 2019 12:10 PM
Jan 27 2019 12:31 PM
Hello,
if you have a list of trailer numbers and their respective license tags somewhere, you can use a lookup function for that. For example Vlookup. In the screenshot, the value of cell A1 is looked up in the master list in column E. If an exact match is found, the license tag from column F is returned.
=VLOOKUP(A1,$E$3:$F$8,2,FALSE)