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.

View 1 Replies


ADVERTISEMENT

Displaying A Picture Based On A Formula

Feb 1, 2014

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.

View 2 Replies View Related

Picture Based On A Value In A Cell

Jul 22, 2009

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]

View 9 Replies View Related

Picture To Change Based On Cell Value

May 31, 2013

I have posted example work book

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.

View 3 Replies View Related

Show Picture Based On Cell

Dec 31, 2006

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)

View 3 Replies View Related

Loading Picture To Userform Based On Cell

Oct 23, 2013

I'm working on an excel table in which I have the following information:

Product
Date
Defect
Defect Picture

N65-P0421
09/15/2013
Broken tab
D:folderpicture.jpg

N65-P0322
09/16/2013
scratches
D:folderpicture1.jpg

I need a userform in which I choose the field "product" and it loads the picture from the path at "Defect Picture". Is it possible?

View 2 Replies View Related

Insert Picture Based On What Is Typed In Cell?

Mar 27, 2013

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.

View 1 Replies View Related

Macro To Show A Picture Based On A Certain Cell?

Apr 25, 2014

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.

View 1 Replies View Related

Display Picture Based On Text In Cell

Feb 28, 2008

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?

View 3 Replies View Related

How To Show A Picture In Excel Based On Cell Data

Jan 10, 2005

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.

View 3 Replies View Related

Insert Picture Based On Exact Cell Value From Folder Using VBA

Oct 4, 2013

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.

A B
Style_code Picture
1
2
3
4

View 9 Replies View Related

Excel 2003 :: Deleting Or Displaying Rows Based On Cell Content One By One

Mar 20, 2014

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.

View 4 Replies View Related

Display A Picture In A Cell When The Picture Name Is Selected

Jun 18, 2014

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.

View 6 Replies View Related

Excel 2003 :: Put Picture Into A Cell And Get Picture Name From Another Cell

Mar 23, 2014

I want to paste/show a photo in a particular cell (D2) on a worksheet (called PP). I wish to delete any photo that may already be there in D2.

The picture's name (e.g. J-145.jpg) will be found in another sheet (called MP) in cell H1.

My pictures are stored in a folder (lets call it c:pictures) and the one I want has the same name (J-145.jpg).

I've tried many macros but none work.

View 14 Replies View Related

Write The Picture Name In Cell The Picture Will Appear

Jan 22, 2009

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.

View 10 Replies View Related

Displaying Number Based On Dropdown Box?

Mar 13, 2014

In col b10 I have a drop down list box with numbers

e,g, 10
12
14
16
18

Now I am seeking a formula that when say 12 is selected in B!0 a predetermined number is displayed in C10 I have attached an example

View 4 Replies View Related

Displaying Data Based On Drop-down Menus

Sep 28, 2009

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.

View 6 Replies View Related

Displaying Data Based On Selected Worksheet

Dec 21, 2006

An integer in stored in Sheet1!A1. I want a formula in Sheet1!A2 to display data of sheetx!A3 where x is the number chosen in Sheet1!A1.

e.g. Sheet1!A1 store 3. Then Sheet1!A2 will display Sheet3!A3.

e.g. Sheet1!A1 store 7. Then Sheet1!A2 will display Sheet7!A3.

View 10 Replies View Related

Populating Picture Based On Number?

Jul 2, 2014

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.

View 3 Replies View Related

Excel 2010 :: Paste Picture Into Small Picture / Diagram Box?

Mar 19, 2012

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?

View 1 Replies View Related

Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Nov 18, 2007

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

View 6 Replies View Related

Displaying MIN Date Based On Criteria In Calculated Field Of PowerPivot?

Jan 23, 2014

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.

View 2 Replies View Related

Displaying Combined List Of Names Based On Several Column Cells?

Jun 25, 2014

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.

View 6 Replies View Related

Displaying Automatic Dates For Lookup Based On Year Selected

Aug 3, 2014

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.

Attached is a simplified example of what I mean.

View 7 Replies View Related

Inserted A Listbox And Based On The Value Selected A Picture Should Be Poped

Jul 12, 2009

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

View 9 Replies View Related

Displaying A Value When There Is A Value In Another Cell

Feb 18, 2010

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.

View 2 Replies View Related

Displaying Next Cell

Jul 19, 2006

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.

View 5 Replies View Related

Displaying Cell Date As 3/14/2001 With Text In Cell

Apr 23, 2012

I have a Cell and the Formula for my Cell is the Following:

Code:
="Week Ending " & 'A01'!D248

The A01 Worksheet displays the value as 4/21/2012 . However, the first worksheet displays the value as

Code:
Week Ending 41020

rather than

Code:
Week Ending 4/21/2012

What can I do to display the cell the way that I want to? I've already tried formatting the cell directly as Date to no avail.

View 3 Replies View Related

Displaying Nothing If Another Cell Has A Text Value

Jan 21, 2010

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.

View 6 Replies View Related

Displaying Certain Coloured Cell

May 27, 2006

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.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved