How do I get rid of the link??? I have been up all night trying to figure this out and no help anywhere.
My formula seems like it is not working because it has a link which I cannot find anywhere.
dog.xlsx
Screen shot 2014-01-05 at 2.38.08 AM.jpg
How do I get rid of the link??? I have been up all night trying to figure this out and no help anywhere.
My formula seems like it is not working because it has a link which I cannot find anywhere.
dog.xlsx
Screen shot 2014-01-05 at 2.38.08 AM.jpg
Take a look at these formulas.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
I am still getting the message in the report. Formula contains a link to a closed workbook?
here is a screen shot
Screen shot 2014-01-05 at 3.10.46 AM.jpg
Also, why didnt the original formula work? What did I have wrong?
I don't get the message, I can't help you with that.
I adjusted the search range.
yes that book works fine
why do you have
=MATCH(Log!G$1,Inventory_Sheet!$A$9:$H$9,0)
when it should be
=MATCH(Log!G$1,Inventory_Sheet!$A$1:$H$1,0)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I don't get the error that you show concerning links.
I think that the formula in log!G2 should be this which you can copy across and then down as far as needed:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
figured it out. Please delete this thread. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks