Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing XML to Excel - XML Parse Error | Excel Discussion (Misc queries) | |||
How in to parse constants in formula to cells | Excel Programming | |||
VBA - Error Using Mid To Parse A Data (.dat) File | Excel Programming | |||
How do I capitalize and parse in the same formula? | Excel Worksheet Functions | |||
Parse formula | Excel Programming |