VLOOKUP Equivalent using openpyxl

[DJBuck]

Hi, apologies for any naivety but I am only just beginning my foray into the world of python!
I am looking to extract data from an excel spreadsheet, utilising something similar to the VLOOKUP function in Excel.

Would someone be able to talk me through this?
For example, if I had a table of data:
A 1
B 2
C 3

I would like an input variable of "A" to retrieve the corresponding value 1.

Thanks in advanced, I imagine it isn't a complex task but being so very green I need a hand!

[Larz60+]

see: https://automatetheboringstuff.com/chapter12/
And there is pandas: https://pbpython.com/excel-pandas-comp.html
(other tutorials are available, use google)

[DJBuck]

Thanks, I'll look into it!