Parse error with formula
I am trying to pull data from one sheet to another, I got that to work but wanted to have a 0 for #NA. This is what I got from my research:
=IF(ISNA(Vlookup(A3,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1wCVX8qXvBo_WfSR0NuFai-zXuSjPinmDChn4lKJZ2Cc/edit#gid=961497420","'log.export'!H3:I9"),2,0))"0" ,Vlookup(A3,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1wCVX8qXvBo_WfSR0NuFai-zXuSjPinmDChn4lKJZ2Cc/edit#gid=961497420","'log.export'!H3:I9"),2,0)) I keep getting a parse error. I am not sure what is causing it. -- This message and any attachment thereto is for the sole use of the intended recipient(s), and is covered by the Electronic Communications Privacy Act (18 USC 2510 et seq.). It may contain information that is confidential and legally privileged within the meaning of applicable law. If you are not the intended recipient, please immediately alert the sender by reply e-mail, permanently remove this message and any attachments thereto from your system, and destroy any hard copies thereof; do not disclose the contents or take any action in reliance upon the information contained in this message or any attachments. If you have any doubt as to the authenticity of this message or any attachment thereto, please contact the sender immediately. Any copying, disclosure, distribution or other action taken or omitted to be taken with respect to an erroneously received or inauthentic message or attachment is prohibited. |
All times are GMT +1. The time now is 11:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com