Hi,
I was wondering if there were limits to the Application.Evaluate?
I'm trying to runwhere the formula is: FileLookupColumnG stored as a named formula
Please Login or Register to view this content.
and
FileLookupColumnG = =SUMPRODUCT(IF(ISNUMBER(Output!$G$4:$G$846)(Output!$A$4:$A$846=INDEX(INDIRECT(ADDRESS(ROW(),1,)),1))*Output!$G$4:$G$846,0))
Not sure why the formula doesn't evaluate?
Does the formula working in Excel?
Can you send a short sample of your Excel file.
- Battle without fear gives no glory - Just try
I cannot send a file unfortunately without recreating data and so on and son. But yes the formula works in Excel.
The formula syntax is invalid. Try putting it in a cell.
Entia non sunt multiplicanda sine necessitate
I have some doubt how the formula is working, see the )( inside ...!
You're 107% correct, not sure where that other parenthesis is coming from. Trying again
Please Login or Register to view this content.
Shg wud up man. Next time I'm back home in the Great Country of TX I owe you coffee or something
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks