danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
Hello,
I would like to load this table into power query.
When I go to Data ribbon -> From Table, it only displays the values and not the formulas.
How do I keep the formulas within my tables?
Thank you
[/FONT]
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
1 | Invoice | Date | Amount | Booked | ||
2 | M0121032 | 19-Mar-19 | 101.48 | Booked | ||
Coynes |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2 | =IFNA(IF(MATCH("*"&B2&"*",'[22.07.2019 Consolidated.XLSX]Sheet2'!K:K,0)>0,"Booked","Not Booked"),"Not Booked") |
Hello,
I would like to load this table into power query.
When I go to Data ribbon -> From Table, it only displays the values and not the formulas.
How do I keep the formulas within my tables?
Thank you