search

Strumenta / article-python-excel

Code for the article "Working with Excel in Python"
Apache License 2.0
2 stars 0 forks source link

Formula issue between sheets. #1

Open lindev0915 opened 3 years ago

lindev0915 commented 3 years ago

It's failing when the formula try to calculate between sheets.

=IFERROR(VLOOKUP(A8,'CS paste ydays close'!$A$1:$Z$35,'CS paste ydays close'!H$1,FALSE),"")
lindev0915 commented 3 years ago

price_reference.xlsx

alessiostalla commented 2 years ago

Right. It's mentioned in the article that the code shown is simplistic and doesn't support cross-sheet references or, even worse, cross-file references. IIRC the format of these is not even standard – Excel uses one, Apple Numbers another.