Search results

Oh! CRAP! January to February worked but now I can't get March to work. I'm trying to use the following formula in my "March" tab =IF(February!A3="","",HYPERLINK(January!A3,February!A3)) Nothing happens the cell just leaves the text of the formula in it and gives me the "This cell is...

I GOT IT!!!!!! Yeah!! I added a column in sheet "January" for the hyperlink to store in and added the hyperlink in A3 and also to the text in B3 (so 2 of the same hyperlink in sheet "January".) This is the formula I am using now. =IF(January!B3="","",HYPERLINK(January!A3, January!B3))...

I did try it on a blank spreadsheet and was able to get the formula to work as long as there wasn't any text in the cell. Looks like that is my issue at this point. However, I really need to have that product number in there. If you have any ideas I greatly appreciate it. Thank you for...

That's exactly what I want to do, however for some reason it is not working for me. Could it be because I have text in cell A3 where I also want to include the hyperlink? In cell A3 on sheet "January" tab (text includes a product number "KLP001") I created a hyperlink to a picture on my...

Also, I did take off the last "" as the text in JanuaryA3 did not come across and still received error.

Thank you so much for your reply! Darn it thought. I get an error "Cannot open specified file".

I have an excel spreadsheet. I have my first tab labeled January. I have a tab for every month. February is linked to January, March to February etc with the following formula =IF(January!A3="","",January!A3). I have a hyperlink (to a picture) in Sheet JanuaryA3 and would like that hyperlink...