L9G WEST =VLOOKUP(A2,$A$7:$B$29,2,0)
L8W EAST =VLOOKUP(A3,$A$7:$B$29,2,0)

maybe this helps?

L9H WEST
L9G WEST
L9K WEST
L8S WEST
L9C WEST
L8P WEST
L9B WEST
L8R west



L8N EAST
L9A EAST
L8W EAST
L8V EAST
L8M EAST
L8L EAST
L8T EAST
L8K EAST
L8H EAST
L8G EAST
L8J EAST
L8E EAST