Hello!
Can someone help me to make a formula that finds value from another table based on station name? I have tried using match and lookup function, but I can't get it work.

Station Latitude Longitude Other data
1a ? ?
4a ? ?
2a ? ?
3a ? ?
1a ? ?
2a ? ?

1a 57.42342 29.54323
2a 56.78943 28.34257
3a 57.93653 28.57217
4a 58.19241 29.63312