[libreoffice-users] calc

Say I have column A with the numbers 1, 2, 3:
A1 (1)
A2 (2)
A3 (3)
and column B with the numbers 11, 22, 33:
B1 (11)
B2 (22)
B3 (33)

Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch 
which row is referenced so I can see the effects of different choices).

Is there a calc function which can find which row I chose so I 
automatically populate row 4, column B?
Row 4, column A matches one of the rows 1-3...

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy