Watch a bunch of "Picture-Lookup" vids to wrap my mind around the basic concepts. Of COURSE, your video was the most straightforward, easiest to follow AND replicate, and, best of all, my lookup works perfectly. THANK YOU for sharing!
I guess im asking randomly but does anybody know of a method to get back into an instagram account?? I somehow lost the account password. I appreciate any help you can give me.
Finally managed to make it work. You must be VERY accurate. IMPORTANT. The photo MUST be smaller than the cell that it is in. Thanks for your help. DAVE
Hi guys. Computergaga Thank you so much for the great video really well done. Just as a note I was also getting a 'reference error' and I had followed the steps correctly. The problem I was facing is that in the Match cell in you example D2 Japan mine said Serbia but in my flags sheet Serbia was labelled as Serbia Montenegro so the match could not happened something like Great Britain as UK in the D2 cell would also throw it out. Anyway I hope this helps someone else. Thanks again for the great video. Much Respect from Dublin :-)
Hi Alan.. excellent.. so clever! Would work well for a roster of names with pictures like a customer list or suppliers with logos, etc. Thanks for sharing it. Thumbs up!
You can use INDEX or XLOOKUP. There is also an IMAGE function due for release soon (mentioned in my community posts). Volatile is only bad if you're handling large volumes. Depends on the spreadsheet.
@@Computergaga I tried index and xlookup. They are all volatile regardless when used in name manager. For example, just make 4 dynamic images. And any macro will slow down to extreme below hell. I don't know about the image function since I use 2021 offline version. Anyway I solved the problem myself: I created a name(Pictureif) in name manager. This name(Pictureif) equals to =if(a1=1,xlookup(etc),"") And the name(Picture) equals to Pictureif. When I change a1 to zero, Excel is fast. I only change it to 1 when I need the pictures to change dynamically. Then I change the the value of 1 to 0 and the picture don't change dynamically anymore. That's the only practical and fastest and Damn Real solution I found, by my very self.
That's a really good, clear video, and it's clear that it should work, but I am having the same issue as some others, as I get the "reference isn't valid" report after the final step. The pictures are fully contained in the cell, and the formula is correct because it works fine when it's in a cell (rather than name manager), although it just reports a zero.
Make sure you have a picture in the cell where the picture is returned. Ensure it is selected and you click in the formula bar before you write the link to the named range. I think the problem exists around the time you link the picture so check the steps around this area.
I've just got it to work. I had to hit F4 after entering each cell in the formula and it did the trick. I don't fully understand why though. Thanks again, excellent video, very clearly explained.
You could add an IF function around the formula in the named range. Imagine that the value is entered into cell D2 you could enter =IF(Sheet2!$D$2="",Sheet2!$A$100,.......) The Sheets2!$A$100 reference is a reference to a blank cell. And the ...... is where the INDEX and MATCH from the video would be.
that's not bad and it seems like it would be a lot more flexible with repeating the image Brilliant it works. It's a bit of work to get the ranges down. I couldn't drag and drop. Need to do some testing with named ranges but beyond that.. excellent
Bugger.. no idea what i did but entering the picture formula gives reference invalid when I try to do it on a separate sheet. I think it might be a spaces thing or an indirect thing.
Same problem here. I am looking for a way to put the logo of a trademark whenever I type de trademark name in another column. So, in one column the trademark names and in an adjacent column, the trademark logo. Could you help me, please?
I have replicated your worksheet exactly, step by step. When selecting the pic and entering "=FlagPic", it returns "Reference isn't valid". I have retraced my steps repeatedly. Is this method applicable to a more recent version of Excel?
This approach should work in all versions. It can be awkward though. I have a more modern version that uses XLOOKUP th-cam.com/video/lQPIrZkDNro/w-d-xo.html
Difficult to say without seeing. When you linked the picture to the defined name, did you have the picture selected? Did you type it into the Formula Bar? And did you start with =?
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.
I need some additional help. I'm creating a list where I want to select the name of a person and have their image appear. I need this formula to apply to multiple cells across an entire worksheet. I was able to get the image to appear in the first cell but it is filling in a single image on all of the rest of the cells. Do I need to do this process for each cell that I want to apply it to? I'm selecting Student Name 1 in cell A1, and Student 1 image is appearing in Cell B1-B15.
In the video when I reference cell $D$2 for the country name. Remove the dollar from the row number so it is not fixed. It would read $D2. This should work.
@@Computergaga - Thank you! But it's nonsense. The NAME we give is attached to a single cell reference (that can be changed as you've said) and to a single image (that's the problem).
@@Computergaga - I got an error "Invalid Reference" every time I try to get rid of that "$" sign there... Now I could make this work but it seems that that's NOT the workaround we need to make Excel understand that those pictures should change by the data of the names column. It will be looking for the first cell reference no matter what. I can't pull it down and the formula updating for each row I drag over... That's not an "IN CELL" formula, right? It seems that we'll need to build a single "NAME" for each row - now think about more than 500 names (rows) time-consuming...
Great Post! is it possible can we expand it, for example: if I have a list of toys and these will be looked up with Category codes, lets say there is a category of Car and it would contain more than one picture, similarly category Bike would have its own list of more than one picture, is it possible to have all the picture albeit in separate cell if I were to select a car category. Appreciate your feedback. Thanks in advance.
Thanks for the prompt reply. Perhaps if you have time can you do a similar awesome style video to teach us. Again, appreciated the video and the comment.
How are you supposed to reference if you have the image in a formatted table? I've tried multiple ways by Table1[#all] but also just single columns in the table. None seem to work.. Have you managed to be succesful here? Grateful for any tip!
I just tried NRCS and have had no luck. I set up the formula using reference as Table1[name] where name is the column header. I set up the formula in the named range fine. But I could not assign the name to the pic. It said the reference is not valid.
Love it!! thank you so much!! However when the my reference cell is blank i don't want the pic to stay there i would like it to be blank as well...is that possible?
I don't think we can do this with the formula in the way we can with cell values. You could however insert a blank white image at the bottom of the list, not visible to people. So when the cell is blank, it searches for and returns a blank picture that you would not see.
Thanks - I'm am not able to complete this exercise though. I the last step is throwing an error message: Reference isn´t valid. Any idea what might be causing it? I've read through the comments and tried everything but still no luck?
Never mind - I have figured it out. For those who have tried everything and still get the error message: Reference isn't valid, try this: Make sure that the actual cells are selected when you are pasting your pictures in, so that the pictures are anchored/associated with the cells. Then when you try to link your defined name, your index and match functions will have something to reference and return. I hope that makes sense and is helpful.
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.
I don't know without seeing it. There will be a mistake in the process. Check through the steps again checking for typos and making sure you typed = in the Formula Bar.
Are you receiving the error "Reference isn't valid"? Make sure your source data is not in a tabular form, convert the table into a range before proceeding. Besides typo errors, other key things to remember are not keeping the lookup value empty and selecting the cell containing the picture (not picture itself) while trying to copy it to the resultant cell.
Sure, if you have a lot of pictures. The video will provide some sample code as an example. You can learn about VBA on my course if you are interested - www.udemy.com/excel-vba-course/?couponCode=TH-cam10
+Rosi Nomis solved it...I used the german version of Excel..... therefor the formular is supposed to use semikolon( ;) instead of komma(,) and "match" becomes "Vergleich"...then it works great!.. Thanks again for sharing it with us...
Hello Sir, i did exactly what is shown on this video, but unfortunately the define name part cannot accept the formula typed. it says that there is a problem with this type. Do you know why?
You're very welcome. In the UK, US, Canada etc a comma is used to separate function arguments. But because a comma is used as a decimal separator in Europe, a semi column - ; - is used instead.
I want to transfer picture from another excel sheet to one I am manage data, I have follow your instruction , and looks all right, but last step when put name of like you did " flagPic", it shows 0 in cell, I wonder why is that, first I tought it my be size of picture, fo I need to adjust size of picture to fit cell, I have tried that too , but no , it does not work, please any advice I have so many picuture to fit code name and doing old way it will take me 5 days to do it. please help
Hi Marina, the "flagpic" is entered on the picture, not the cell. I clicked on the flag image in cell E2 and wrote =flagpic in the formula bar. This may be where you went wrong. I hope it works.
I have tried this , but then excel stop working, probably to much data in file, I have a lot of formula in it and this just is to much, I notice when I have opened 2 excel files , excel very often stop working so must save to often to not lose data. thank you any way, I will try in smaller data just to test when catch some free time.
When I go to put the formula on the picture it says "Reference is not valid". Everything seemed to work up to this point where am I messing up at? Thanks!
Hello, I have a problem with the last step. I can't add a formula flagpic to picture. When I click on the pictire I am not able to add name. Can you advice me how to fix it? Maybe I have done any mistake. Thanks in advance
Once you have the named range set up with the formula. You need to click on the pic, then in the Formula Bar type = and then FlagPic, whatever you called it.
Thanks dude, this is sort of what I was looking for so it has helped me in some way atleast :) Perhaps you can help me further though please. I have a list of items (Not a singular pulldown), how can I associate a picture adjacent to the list corresponding to each row? Using your example, lets say a list of countries (there will be repeats) and each time a row is added to the list, the representing flag will also appear. Is that possible using this method?
Just a thought, how do I return a black when nothing selected, as it stays on what ever image was last selected. I have tried adding a black image but doesn't work ? Thanks
You could probably create a blank entry in the list and then extend the formula to include blank cell with black or empty picture. So effectively this is returned by the lookup. You could maybe get a transparent picture and use Conditional Formatting to turn the cell black.
Thank you so much. I think you are the only one in TH-cam with this explanation. But for me is just a piece of the cake. Please, help me with something else. What can I do if the pictures are in different sheets? I have a data in different sheets by classification. I can do this with the text data using combination of iferror + vlookup. And I tried the same thing with the pictures combining iferror + your video but didn't work. Maybe I didn't know use the correct formula. Please SOS.
How could I make a column with trademarks names and an adjacent column with their logos, for example? Could you give me some hand on this, please? No Dropdown list... For Example: =INDEX(CAMPAIGNS!$B$2:$B$57,MATCH(CAMPAIGNS!$D$3,CAMPAIGNS!$A$2:$A$57,0)) The term reference $D$3 is the name of the trademark that is used to chose the logo. It works perfectly. But, if I HAVE ALMOST 500 trademarks here... ...I'll need to build a NAME formula for each row, right?
@@Computergaga - So, using the method explained in this video, I should build as many "NAMES" functions (formulas) as the number of rows I intent to have, right? It will be a really annoying way to make it work, don't you agree?
I sure do. Using the technique in the video yes. But this method was demonstrated without your scenario in mind. There will be better ways to acomplish this, VBA to start with. There is probably a formula solution more targeted to your example. But not one I can conjure up right now.
@@Computergaga Ok. Thank you for your replies, anyway. I am looking for it for some weeks and all I could find was the same solution you generously give to us. Thank you for this video, too.
I have solved the issue with no picture showed by referring another tube. The key is that you must first do a copy-paste with an option of linked picture.
Difficult to answer without knowing what you have. Re-check the formula used in the defined name. And check that the picture is linked to that defined name.
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.
I looked for a long time, and found a couple different ways that people accomplish this task, but by far, this is the easiest one. Thank you so much!
You're welcome. Thank you Dean.
Watch a bunch of "Picture-Lookup" vids to wrap my mind around the basic concepts. Of COURSE, your video was the most straightforward, easiest to follow AND replicate, and, best of all, my lookup works perfectly. THANK YOU for sharing!
It is my pleasure Milburn. Thank you for your comments.
Thank you so much!!!! I read countless instructions on how to do this--this video definitely takes the cake!
I guess im asking randomly but does anybody know of a method to get back into an instagram account??
I somehow lost the account password. I appreciate any help you can give me.
Finally managed to make it work. You must be VERY accurate. IMPORTANT. The photo MUST be smaller than the cell that it is in. Thanks for your help. DAVE
No problem Dave, good work.
I am an excel geek and couldn't solve for this until I saw your nifty methods. Thanks and Bravo!
Thank you.
Hi guys. Computergaga Thank you so much for the great video really well done. Just as a note I was also getting a 'reference error' and I had followed the steps correctly.
The problem I was facing is that in the Match cell in you example D2 Japan mine said Serbia but in my flags sheet Serbia was labelled as Serbia Montenegro so the match could not happened something like Great Britain as UK in the D2 cell would also throw it out. Anyway I hope this helps someone else. Thanks again for the great video. Much Respect from Dublin :-)
Thank you so much! This was the easiest to understand and the easiest to follow. You are an awesome instructor!!!
Thank you Phil.
Yet again, worked perfect (once I followed your instructions exactly !)
Thank you
At last a solution that works with Mac. Thanks, you saved my day.
Great! That is what I like to hear. My pleasure.
Thank you very much, spent lot lot of time on this and many ytb videos. This one made me to do it on the very first try. I appreciate
It is no trouble Juraj.
You explained very very simply. Perfect. Thank you👍👍👍👍👍👍👍
You're welcome. Thanks, Xalid.
Awesome! Only tutorial I found that was simple and easy to understand for the unsavvy Excel user! Thanks a lot!
You're welcome Vladimir, thank you.
Thank you, a really clear explanation. I managed to do this for the first time after watching your video
thanks man i watched 10 other ones but you's is the best
Excellent! Thanks 😊
wow. This worked great and so easy!; i watched 3 other people on YT try to explain 3 other ways and none worked.
Excellent! 😊
Super helpful , thank you 👍🏼👍🏼👍🏼
You’re welcome 😊
Exactly what I needed! Thank you!
Great to hear Ernest. You're very welcome.
Thanks in a million Robert. What an inventive mind. A++
Robert? But thanks.
Hi Alan.. excellent.. so clever! Would work well for a roster of names with pictures like a customer list or suppliers with logos, etc. Thanks for sharing it. Thumbs up!
Absolutely yes. Excellent for forms and reports.
Well thought-out, clever concept, clear explanation.
Thank you newporter42.
جزاك الله الف خييرر شكر جزيلاً على الشرح الواضح استفدت كثيييررر
وجزاك الله خير
You're welcome.
This is volatile. It slows down excel and especially macros. Is there a non-volatile way?
You can use INDEX or XLOOKUP. There is also an IMAGE function due for release soon (mentioned in my community posts).
Volatile is only bad if you're handling large volumes. Depends on the spreadsheet.
@@Computergaga I tried index and xlookup. They are all volatile regardless when used in name manager. For example,
just make 4 dynamic images. And any macro will slow down to extreme below hell.
I don't know about the image function since I use 2021 offline version.
Anyway I solved the problem myself: I created a name(Pictureif) in name manager.
This name(Pictureif) equals to =if(a1=1,xlookup(etc),"")
And the name(Picture) equals to Pictureif.
When I change a1 to zero, Excel is fast. I only change it to 1 when I need the pictures to change dynamically. Then I change the the value of 1 to 0 and the picture don't change dynamically anymore. That's the only practical and fastest and Damn Real solution I found, by my very self.
What a fantastic video - thank's for sharing.
That's a really good, clear video, and it's clear that it should work, but I am having the same issue as some others, as I get the "reference isn't valid" report after the final step. The pictures are fully contained in the cell, and the formula is correct because it works fine when it's in a cell (rather than name manager), although it just reports a zero.
Make sure you have a picture in the cell where the picture is returned. Ensure it is selected and you click in the formula bar before you write the link to the named range. I think the problem exists around the time you link the picture so check the steps around this area.
I've just got it to work. I had to hit F4 after entering each cell in the formula and it did the trick. I don't fully understand why though. Thanks again, excellent video, very clearly explained.
This worked great for me. Thank you. But is there a way that no image appears when no value is entered?
You could add an IF function around the formula in the named range. Imagine that the value is entered into cell D2 you could enter =IF(Sheet2!$D$2="",Sheet2!$A$100,.......)
The Sheets2!$A$100 reference is a reference to a blank cell. And the ...... is where the INDEX and MATCH from the video would be.
This was great, exactly what I was after. Thank you so much!
Very easy to follow. Thank you.
You're welcome thepeterson.
already tried, but instead of picture the result is 0, seems like the formula gets the cell value and not picture in the cell
that's not bad and it seems like it would be a lot more flexible with repeating the image
Brilliant it works. It's a bit of work to get the ranges down. I couldn't drag and drop. Need to do some testing with named ranges but beyond that.. excellent
Bugger.. no idea what i did but entering the picture formula gives reference invalid when I try to do it on a separate sheet. I think it might be a spaces thing or an indirect thing.
Thank you, its really what I need to learn.
Excellent! You're welcome.
Perfect demonstration, I am up an running, cheers!
Good to hear Eduardo, well done.
Same problem here.
I am looking for a way to put the logo of a trademark whenever I type de trademark name in another column.
So, in one column the trademark names and in an adjacent column, the trademark logo.
Could you help me, please?
I have replicated your worksheet exactly, step by step. When selecting the pic and entering "=FlagPic", it returns "Reference isn't valid". I have retraced my steps repeatedly. Is this method applicable to a more recent version of Excel?
This approach should work in all versions. It can be awkward though. I have a more modern version that uses XLOOKUP th-cam.com/video/lQPIrZkDNro/w-d-xo.html
Super helpful please keep up the videos
Will do. Thanks, Ronald.
thanks. this helps me a lot in my project
You're welcome!
Alan, Can we take this one step further and add the pics to a pivot table?
I'm not sure that is possible Cam. Not something I have done.
Great Video Alan, many thanks!
cheers
Mohideen
Thanks Mohideen.
What are the cell sizes of the coloum width and row height?.
Just large enough to accommodate the images. The images must fit in the cells.
I need help from you, i've follow everything that you taught but it showed "invalid reference". May i know how to solve this?
Difficult to say without seeing. When you linked the picture to the defined name, did you have the picture selected? Did you type it into the Formula Bar? And did you start with =?
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.
I was looking exactly do to this thing. Thanks a lot
I need some additional help. I'm creating a list where I want to select the name of a person and have their image appear. I need this formula to apply to multiple cells across an entire worksheet. I was able to get the image to appear in the first cell but it is filling in a single image on all of the rest of the cells. Do I need to do this process for each cell that I want to apply it to? I'm selecting Student Name 1 in cell A1, and Student 1 image is appearing in Cell B1-B15.
In the video when I reference cell $D$2 for the country name. Remove the dollar from the row number so it is not fixed. It would read $D2. This should work.
@@Computergaga - Thank you! But it's nonsense.
The NAME we give is attached to a single cell reference (that can be changed as you've said) and to a single image (that's the problem).
@@Computergaga - I got an error "Invalid Reference" every time I try to get rid of that "$" sign there...
Now I could make this work but it seems that that's NOT the workaround we need to make Excel understand that those pictures should change by the data of the names column. It will be looking for the first cell reference no matter what.
I can't pull it down and the formula updating for each row I drag over...
That's not an "IN CELL" formula, right?
It seems that we'll need to build a single "NAME" for each row - now think about more than 500 names (rows) time-consuming...
@@marceloribeirosimoes8959 man, I have been trying to solve this as well. did you find a solution?
@@diogodemoraes8591 Not a real good one, yet...
Great Post! is it possible can we expand it, for example: if I have a list of toys and these will be looked up with Category codes, lets say there is a category of Car and it would contain more than one picture, similarly category Bike would have its own list of more than one picture, is it possible to have all the picture albeit in separate cell if I were to select a car category. Appreciate your feedback. Thanks in advance.
I don't see why not. It would take some formulas to return each picture from the range 2nd, 3rd etc.
Probably easier done with VBA this kind of task.
Thanks for the prompt reply. Perhaps if you have time can you do a similar awesome style video to teach us. Again, appreciated the video and the comment.
Thank you. I will do my best.
How are you supposed to reference if you have the image in a formatted table? I've tried multiple ways by Table1[#all] but also just single columns in the table. None seem to work.. Have you managed to be succesful here?
Grateful for any tip!
I just tried NRCS and have had no luck. I set up the formula using reference as Table1[name] where name is the column header. I set up the formula in the named range fine. But I could not assign the name to the pic. It said the reference is not valid.
I got it to work with Table1[[#All];[ColumnHeader]]. Now works like a charm, thanks!
Very excellent, clever
Thank you Majid.
Love it!! thank you so much!!
However when the my reference cell is blank i don't want the pic to stay there i would like it to be blank as well...is that possible?
I don't think we can do this with the formula in the way we can with cell values.
You could however insert a blank white image at the bottom of the list, not visible to people. So when the cell is blank, it searches for and returns a blank picture that you would not see.
How can I copy this down so I can have a list of 10 and all pictures match the list? I can only make the first 1 work after that nothing changes.....
Thanks - I'm am not able to complete this exercise though. I the last step is throwing an error message: Reference isn´t valid. Any idea what might be causing it? I've read through the comments and tried everything but still no luck?
Never mind - I have figured it out. For those who have tried everything and still get the error message: Reference isn't valid, try this: Make sure that the actual cells are selected when you are pasting your pictures in, so that the pictures are anchored/associated with the cells. Then when you try to link your defined name, your index and match functions will have something to reference and return. I hope that makes sense and is helpful.
Good work Clinton.
...having difficulty associating the pic with the cell. Clinton, any feedback?
I need some additional help also. When I get to the last step where I am to name my pic, it's returning a message "Reference Isn't Valid".
Make sure the pictures are completely enclosed in the cell. There is a comment by Clinton Deavall who seemed to have the same issue.
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.
I cannot get picture in D2 but 0. The office that I used is 2010.
any solutiın for mac users.. I have excel for mac 2016
Sorry, I don't use a Mac.
Thank you. This is very helpful. :)
Your welcome, epicham08.
Does anybody knows how to do this in OpenOffice? I have to do somthing like that, but it has to be OpenOffice document.
Hello, this is very interesting, but it does not seem to work for me, I have just done as on the video, what am I doing wrong? Could you help me?
I don't know without seeing it. There will be a mistake in the process. Check through the steps again checking for typos and making sure you typed = in the Formula Bar.
Are you receiving the error "Reference isn't valid"? Make sure your source data is not in a tabular form, convert the table into a range before proceeding. Besides typo errors, other key things to remember are not keeping the lookup value empty and selecting the cell containing the picture (not picture itself) while trying to copy it to the resultant cell.
Thanks a lot Mr,Alan
You're welcome Hazem.
Can the picture be a reference to a JPG File that is not in an Excel Sheet or Workbook but rather from a folder in the computer?
I would use VBA for this approach. I have a video on that here - th-cam.com/video/VUl3l9wB51M/w-d-xo.html
unfortunately I have not coded with VBA. Creating a sheet with the pictures in it would bloat the file imensely. :(
Sure, if you have a lot of pictures. The video will provide some sample code as an example.
You can learn about VBA on my course if you are interested - www.udemy.com/excel-vba-course/?couponCode=TH-cam10
Hi, Thanks for the video.. I also always get the error "invalid reference"... may you help?
+Rosi Nomis solved it...I used the german version of Excel.....
therefor the formular is supposed to use semikolon( ;) instead of komma(,) and "match" becomes "Vergleich"...then it works great!..
Thanks again for sharing it with us...
Hello Sir, i did exactly what is shown on this video, but unfortunately the define name part cannot accept the formula typed. it says that there is a problem with this type. Do you know why?
Hard to say without seeing it. Check again against the video. There must be something missing. If you live in Europe, swap the commas for semi colons.
I actually live in Europe. Let me check. Btw thank you for your prompt answer.
You're very welcome. In the UK, US, Canada etc a comma is used to separate function arguments. But because a comma is used as a decimal separator in Europe, a semi column - ; - is used instead.
Still not working😔
I have trouble making it in excel 2011 mac, someone who can help?
I receive the following message: Reference isn´t valid. Could you please advise?
+Marc Bellés Bel I get the same result :(
Super Sir.
Thank you Manikandan.
Thank you!
You're welcome!
THANKYOU!
You're welcome ArFeen.
Hey, I have a problem when I need to do the "=FlagPic" because my function bar is close and can't insert anything.
I'm not sure why this is. Check you have no dialogs open and try again.
I want to transfer picture from another excel sheet to one I am manage data, I have follow your instruction , and looks all right, but last step when put name of like you did " flagPic", it shows 0 in cell, I wonder why is that, first I tought it my be size of picture, fo I need to adjust size of picture to fit cell, I have tried that too , but no , it does not work, please any advice I have so many picuture to fit code name and doing old way it will take me 5 days to do it. please help
Hi Marina, the "flagpic" is entered on the picture, not the cell. I clicked on the flag image in cell E2 and wrote =flagpic in the formula bar. This may be where you went wrong.
I hope it works.
I have tried this , but then excel stop working, probably to much data in file, I have a lot of formula in it and this just is to much, I notice when I have opened 2 excel files , excel very often stop working so must save to often to not lose data. thank you any way, I will try in smaller data just to test when catch some free time.
Ok Marina, sounds good.
Thanks, it worked !!!
When I have completed the steps and have got it to work, I can only get a quarter of the picture. Do you know how what I might be doing wrong?
That is strange. Sorry I don't know.
When I go to put the formula on the picture it says "Reference is not valid". Everything seemed to work up to this point where am I messing up at? Thanks!
Hard to say. Double check that the named range was set up correctly and double check your typing. Try again, I'm sure it will be fine.
Can you upload an example file of the result please?
Hello, I have a problem with the last step. I can't add a formula flagpic to picture. When I click on the pictire I am not able to add name.
Can you advice me how to fix it? Maybe I have done any mistake.
Thanks in advance
Once you have the named range set up with the formula. You need to click on the pic, then in the Formula Bar type = and then FlagPic, whatever you called it.
Thanks! very well
Thanks dude, this is sort of what I was looking for so it has helped me in some way atleast :)
Perhaps you can help me further though please.
I have a list of items (Not a singular pulldown), how can I associate a picture adjacent to the list corresponding to each row?
Using your example, lets say a list of countries (there will be repeats) and each time a row is added to the list, the representing flag will also appear.
Is that possible using this method?
Struggling to get this to work. I keep getting the error “reference is invalid” when I apply the defined name to the picture. Any ideas?
Check the named range exists. Even if you think it does. Check. Also check typos.
Computergaga got it to work. The match was looking up in the wrong cell
Just a thought, how do I return a black when nothing selected, as it stays on what ever image was last selected. I have tried adding a black image but doesn't work ?
Thanks
You could probably create a blank entry in the list and then extend the formula to include blank cell with black or empty picture. So effectively this is returned by the lookup. You could maybe get a transparent picture and use Conditional Formatting to turn the cell black.
Thank you so much. I think you are the only one in TH-cam with this explanation. But for me is just a piece of the cake. Please, help me with something else. What can I do if the pictures are in different sheets? I have a data in different sheets by classification. I can do this with the text data using combination of iferror + vlookup. And I tried the same thing with the pictures combining iferror + your video but didn't work. Maybe I didn't know use the correct formula. Please SOS.
THANKS
My pleasure, Dishan.
@@Computergaga you saved my day. extreamly helpful and simple explanation. :)
How could I make a column with trademarks names and an adjacent column with their logos, for example?
Could you give me some hand on this, please?
No Dropdown list...
For Example:
=INDEX(CAMPAIGNS!$B$2:$B$57,MATCH(CAMPAIGNS!$D$3,CAMPAIGNS!$A$2:$A$57,0))
The term reference $D$3 is the name of the trademark that is used to chose the logo.
It works perfectly. But, if I HAVE ALMOST 500 trademarks here...
...I'll need to build a NAME formula for each row, right?
If I understand you correctly, yes. Because it sounds like you have multiple references to a D3.
@@Computergaga - So, using the method explained in this video, I should build as many "NAMES" functions (formulas) as the number of rows I intent to have, right?
It will be a really annoying way to make it work, don't you agree?
I sure do. Using the technique in the video yes. But this method was demonstrated without your scenario in mind.
There will be better ways to acomplish this, VBA to start with. There is probably a formula solution more targeted to your example. But not one I can conjure up right now.
@@Computergaga Ok. Thank you for your replies, anyway. I am looking for it for some weeks and all I could find was the same solution you generously give to us. Thank you for this video, too.
Awesome
Thank you!
nice
Thanks
It says reference is not valid
How do you highlight the picture with the moving dotted lines. I could get the adjoining cell to do it but I couldn't get the picture? Help!
I have solved the issue with no picture showed by referring another tube. The key is that you must first do a copy-paste with an option of linked picture.
Well done
but not printed
I WANT ADVANCED IMAGE AND FORMULA
guess it wont work with *mac*
Sorry, But when i try i found error " Reference is not valid"
Difficult to answer without knowing what you have. Re-check the formula used in the defined name. And check that the picture is linked to that defined name.
I had the same problem. I solved it by making sure the Cell it was looking to match actually contained a Value. It wouldn't accept it at all giving me the same error as yourself as I was trying to lookup a blank cell.