Looking Up And Displaying Picture Based On Cell Value
Nov 13, 2013
I'm looking for a way to insert / display images in a worksheet depending on the value in a cell. The following link is able to do what I need, but it's very limited - i.e. all images must be present in the worksheet first and only the one require is visible:
McGimpsey & Associates : Excel : Display picture based on cell value
I'd prefer to store the images in a normal folder in windows (for a large library of images) and have Excel retrieve the image somehow.
I am working on a spreadsheet that calculates sales results weekly / monthly / quarterly / and year to date. I need to be able to get a picture to automatically populate in a specific fields based on the sales results for that week / month / quarter / year. There are 3 pictures indicating: sales below budget (sad face), above budget but below goal (black dot), and above goal (gold star). I have tried using non-macro means, but I can't seem to get anything to work for use with multiple cells and I do not wish to use conventional conditional formatting. I do not know nearly enough about macros or VBA to even attempt this type of thing.
I have found a few solutions here in the message boards but I don't see one that totally matches what I need. Basically I want it to look up the clients logos. We only have a few clients but when sending the report to a client we don't want them to be able to see or find who our other clients are or their logos. So I need it to display a picture based on a value but to also have the pictures on a seperate sheet that I can delete before distributing.
A variation of this would work but this stores all the pics on the report sheet and just hides the non active ones. [url]
Sheet1 has a list that changes based upon input in Sheet2 So, I have reference pictures on Sheet2 that I would like to show on Sheet1 under the corresponding value.
Explanation: on Sheet two a value is assigned (in column B) to each category (Column A) and then it is ranked (Column C)
Sheet 1 lists the categories in rank order. I want pics to show under each category.
I saw some articles online, but have been unable to make it work.
I have folder with 5 photos on c (c:Pictures). Photos are named a, b, c, d, and e. In Excel workbook sheet1 (c:Photos.xls), how to display the photos in cell range (B1:F10) in response to change in cell A1 (i.e., when A1 cell value is “a”, the photo “a” is displayed in the range B1:F10, and so on when the A1 value changes)
Can I have a picture appear next to what is typed in the cell next to it. I have a drop down list of the different pictures I have, I want to select, for example, "star" from the drop down list, can I have a picture of the star appear in cell next to it? I have all the pictures of the words in my drop down list.
macro which can show a picture of a certain cell and if I change the value of that cell the picture will be changed to the new cell value,
Like
If I put in cell A1 value DOG, so the pic in cell B1 is a dog pic that I defined before, and if I change that value to a cat, the pic should be changed to another pic.
Is It Possible To Embed Pictures So That When I Do Lookup A Code It Then Shows Me The Picture Of What It Is Im Looking For. Ie If I Was To Type In Kettle It Would Show Me A Picture Of A Kettle In The Next Cell?
I have a spreadsheet that queries the web for a weather forecast each day. I'd like to associate pictures on the excel page based on the weather description, but can't figure out a way to select /change the picture automatically.
I am having a product style code in Column A2:A301 from 1 to 300, and I want get picture in next cell ie column B2:B301 based on cell value A2 from a selected folder. Below mention is the snapshot for the same. I am having a product style code in Column A2:A301 from 1 to 300, and I want get picture in next cell ie column B2:B301 based on cell value A2 from a selected folder.
I have a company with upto 5 products, and I have created a dropdown box where you select your product.
When I select product 1 i would need info on product 1 , when i select product 2 I need info on product 1 and 2 and continue. so for product 5 -i need info on product 1-5.
I tried to add all info on excel and tried to delete it one by one by deleting rows in excel for products but it does not work.
I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
i have saved some pictures in my excel sheet. in the next sheet i want that when i write the picture name the picture will appear as vlookup helps in the getting text and nos. can i do this with pictures or i tried to get to much from excel.
I have a very large database, filled with every job we're working on and all the details about it - duties, employees, vehicles, material-costs, etc.
I am currently working on a 1-page "Summary Sheet", that would be used to wade through all of this info and only give me the information I am looking for on one job. I would like to be able to provide drop-down menus on this "Summary Sheet" so that management can pick the information they'd like to see, and not be bombarded by everything else.
Ideally, what I am trying to do is to have a space on top where somebody could enter the name of the job, and then when they pick an item from the drop-down list, it would pull that info from the database via an "Index/Match". When somebody enters a job-name and picks "Joints Tested" from the drop-down, it will only display how many joints were tested on that job.
I already have the drop-downs created, and have other Index/Match formulas in other spreadsheets (they trip me up a bit, but I can generally fiddle with them until they work correctly), but can't figure out how to make it work this way. My database has headings above each column, and I'm writing those same headings next the different options in the drop-down list, but I can't figure it out.
I have a large excel workbook that is full of data about certain parts. I am able to enter a number and populate the sub item using VLookup but I would like to populate a picture based on the sub item. The pictures are located in there own folder inside the folder where this excel file is located.
In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?
I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice
I have a database with a list of transactions with multiple fields, including:
Customer ID Store ID Item ID Date Price
I am wanting to add a calculated field that displays the first (or MIN) Date from the date column, looking at all of the orders where the customer ID, store ID, item ID and price are the same.
In the attached file I have shown what I currently have, as well as a solution using a helper column, and formulas I would use if I wasn't using powerpivot.
I am trying to create a summary Calendar that would display all the names of the people who are off on a given day. I have a grid where I display each day of the month and a person in the group has their own column. If they are out of the office for any reason their name appears in that row. In the big Summary Calendar cell for each day of the month I want to look across all the people columns for that day and then display the names of the people who are not going to be in the office. Can I do this by a formula or will using VBA work best.
I would like to automate a sheet to report statistics of projects based on a single cell that is the year that a user manually inserts. I've got a separate worksheet with all dates manually set up for next 10 years and would like it to be read by formulae in a reporting worksheet based on the year that user enters.
So if I specify year 2014/15 (financial year), I would like the cell C1 under "Reporting" sheet to display 1/07/14 predetermined in "Dates" B3, if I specify 2015/16, the cell C1 will read 1/07/15 from "Dates" B6 and so on.
I could do it with "IF" function but there will be too many nested IF functions in a lot of cells (hundreds if not thousands). This may make my file size very large.
I have inserted a listbox and based on the value selected a picture should be poped. I have searched the forum and got the code below. But it is throwing an error message "object required"
Private Sub ListBox1_Change() If ListBox1.Value = "x" Then Pictures("Picture 1").Visible = True Else Pictures("Picture 1").Visible = False End If End Sub
Then i modified it to
Sub ListBox1_Change()
If listbox1.Value = "1" Then activesheets.Shapes("Picture 1").Visible = True Else activesheets.Shapes("Picture 1").Visible = False End If End Sub
Refer to the attached worksheet. On entering a value into cell C7, I'd like the value of the adjacent column D7 to be displayed in F6. Then when a value is entered in manually into C8, it will then update and put the value of D8 into F6. The idea is an individual will enter a value each week, updating that value. I intend to hide column D.
I want to have a function that finds the largest number in a selection range. However, i want it to display what's in the cell beside it! Example: Say the largest value is in B6 well I was wondering how you would go about displaying the value in C6.
I am using the following math formula in cell C12:
=IF(B12="","",IF(B12<2,-1,INT(B12/5)))
What I want to do is if cell B3 equals a text value of the word "All" then cell B12 would display nothing. If B3 equals any other value then the math formula above be used.
I have a spreadsheet and certain cells are coloured to represent certain criterier, I would like to display all of one coloured cells to show status of that colour, say I want all the red cells locations to be displayed so that i can check the status.