Results 1 to 2 of 2

Insert Image with Formula

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Canada
    MS-Off Ver
    Microsoft 365
    Posts
    41

    Insert Image with Formula

    So I have a formula that has a hyperlink and an importrange associated with it... so the cell where the link and formula is, shows the entire formula in the cell... I'd like for the cell to say "Box" instead of having the entire formula show. How does one do this?

    This is my formula

    =iferror(HYPERLINK("https://docs.google.com/spreadsheets/d/1bPvWRCmrR_yUyQqyca5wpfCoNozKJNJLkkbI9ULpmh8/edit#gid=822632151&range=A" & MATCH(C3, IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bPvWRCmrR_yUyQqyca5wpfCoNozKJNJLkkbI9ULpmh8/edit", "Boxscores!A:A"), 0)),"")

    Thanks for your help.
    Last edited by joerainone; 01-06-2024 at 12:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert the first image found with image search with criteria taken from cell.
    By lifegame1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2022, 10:02 AM
  2. [SOLVED] Insert the first image found with image search (e.g google) with criteria taken from cell.
    By themob212 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 04-14-2021, 12:29 PM
  3. Insert and scale image using Image Control from Active X
    By olga6542 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2020, 06:03 PM
  4. Insert Image With Image Filename In Another Cell - Excel
    By Angelq117 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2016, 09:38 AM
  5. Replies: 1
    Last Post: 02-15-2015, 08:45 PM
  6. Insert image and image name into specific place on sheet
    By ACE23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2014, 04:41 AM
  7. [SOLVED] Insert jpg image from file path to image frame
    By SAsplin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2012, 10:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1