Hi,
I would like to search the 2 lists below for a specific trailer number and return the bay number. Is it possible to search both lists?
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
TRAILER PARK 1
TRAILER PARK 2
Trailer
Bay
Trailer
Bay
TEST
1
TP1
1
TP2...