LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 18th 18, 03:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Oct 2018
Posts: 1
Default 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("","'log.export'!H3:I9"),2,0))"0" ,Vlookup(A3,IMPORTRANGE("","'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.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing XML to Excel - XML Parse Error dlevesque Excel Discussion (Misc queries) 0 March 19th 09 02:55 PM
How in to parse constants in formula to cells [email protected] Excel Programming 51 December 14th 06 09:20 PM
VBA - Error Using Mid To Parse A Data (.dat) File ajocius[_56_] Excel Programming 2 May 22nd 06 03:03 AM
How do I capitalize and parse in the same formula? blondegreenjeans Excel Worksheet Functions 2 December 8th 05 01:57 AM
Parse formula Don Guillett[_4_] Excel Programming 2 January 21st 04 10:07 PM

All times are GMT +1. The time now is 08:18 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017