I think you are perfect. Highly capable, highly intelligent, creative, elegant and also, to state the obvious, extremely beautiful. Thank you for teaching me so much about Excel.
Thank you so much for very clearly demonstrating this function. It works! I used it for a random image picker. Just one problem I keep getting (please kindly reply/comment if you had a similar problem and/or a solution) - the picture "placeholder" I've used kept duplicating itself, and I end up with many pictures pointing to the same named indirect function, lumping on top of each other. I only noticed their existence because they are sometimes not exactly on top of each other (like not very neatly stacked newspaper where you see the layers sticking out from below), and my file quickly got very big after I used a few of these functions. Anyone had a similar problem?
Wow - 446k subscribers! Good for you! I've subscribed. Your videos cover so much ground (I just found this little nugget even though I subscribed a while ago), are easy to follow and your depth of knowledge is outstanding! Keep up the great work.
I agree with @frankkneeland as most other tutorials somehow always miss out a tiny but important detail for those of us who are not excel proficient. Thank you Leila.
Fantastic Tip My Excel Guru!! I wish safety and wellness during this hard time of Covid-19. Thank you again for this tip, i am using this in my office dashboard. all my udemy subscription of your courses has been the most useful thing for me. so thanks!!! Take care excel guru...!!!!
I know i'm late commenting here, but this video was great and just what I was looking for. Does anyone know how this can be set up to work on all cells in a column. So where I have a column of options, when one is selected then the corresponding image appears?
Hi Leila, I hope you are well. This is a great video that I have followed to the letter, but unfortunately my end result is #REF. I am using Excel 365, does your solution only work on 2019? My worksheet fails at the =Flag stage and gives me a "Reference isn't valid" error. Is there a simple step that is commonly missed by other people that I may have missed also? I hope you can point me in the right direction. ***EDIT*** Figured it out - my names in my drop down list data have more than one word, when I named the cells containing the pictures excel replaced the spaces between the words with an "_" . As soon as I changed the names in my drop down list data to be exactly the same (ie with the "_" instead of a space) it worked perfectly. Thanks for a great video :)
Hi Leila. I've tried this over and over and OVER again. I have 106 pictures in a column and have followed your video. Most of the pictures change/update as you have shown but some of the other pictures don't. I can't see any reason why this should happen. Any help would be much appreciated. You have an excellent channel. Always my "go to" for anything Excel.
Thank you for the amazing explanation. However does anyone of you knows why the image loses quality when we insert the formula? My images gets pixelated
Is there a work around to have the same result but without using the name manager? I would like to be able to do this through Excel's Android app, which doesn't have the name manager feature.
Love this idea. I have been looking for a solution for this. I noticed that it does not seem to work if your right column references are numbers ie - 1 2 3 4 or A B C D?
I need your help Leila. I did a via macro which exports a chart as a picture, save it and then attached in a email (inline html image). Everything works fine, but I can't have control in the picture size and quality. The quality is very poor. I've tried different approaches, but now I'm stocked. Any suggestion? thanks.
Hello Leila, thank you for educating video, it really helped me to understand VLOOKUP with images. Is it possible if afterwards we decide to extend list of flags in future (like extension of database) to simple refresh it somehow or all steps must be done from beginning? Reason for asking is that I would like to have some personal database on one Sheet which should be filled in with new data in future. On other sheet I would like to use your function which should be automatically updated with extension of previously mentioned database Sheet. Possible?
Hello, Thank you for the video. I faced some issues. I receive the error #Name? Im not sure where I failed. Before when I did =England in the flag cell it return 0. It might be the cause of it. Any thoughts?
Can the undetected function be used when looking up a drop down list from a search filter formula? Also will it pull images when the names have - or / in them? I was having trouble getting it work? Anyone know? Trying to create a inventory system in excel when you search for a part number it also shows you and image of the part or location.
Please Leila help me, I tried to do this several times step by step but I don't see the pictures in A1 of the report sheet. it just shows a 0. I tried to use JPG and PNG pictures but that doesn't make any difference. How do you link the pictures to the cell, please?
Hi Leila, thank you for this useful video. I benefitted a lot. i am struggling with few things though. I am working on a multiple drop down menu and my selections are not unique, for examples the same header might have two different pictures because it depends on the selection before it. is there a way we can make the picture depend on two different drop downs? in my case there is no way of making the headers unique because they are size ranges and those will always be the same for certain features. I managed to cheat the system by adding spaces when there were no pictures included to make the headers unique, however, this is not working with photos because I have to create a name manager that does not recognize spaces or special characters. can you post a video that has headers that repeat but have different drop downs or provide a formula that allows the dropdown to depend on two lists? or a way to include headers with spaces without showing the "_" in the selection as a space?
Thanks Leila. It is cool. I have a question to ask please. As defining Name in Name Manger, Excel doesn't allow space. To get around, I put an underline in between words of a country name. However, it looks bad in presentation to select the country name with an additional underline. Do we have a get around solution for a better presentation please?
Hi Karen. In that case, all you have to do is to use the substitute function inside indirect. I'm not at my PC now but I provided an example in the comments below here in response to a similar question from someone else. Please have a look.
Hi Leila, does this method work for value in spilled array? Tried the filter formula to get country, then indirect formula in name manager. It only captures the first value and not for the ghosted formula even though it shows the right country. Thanks in advance.
hello Leila! very useful video. i managed to do it however I have small problem. when i choose to save as PDF, the photos don't display when opened with Adobe Acrobat or any other PDF viewer. do you know what might be the problem?
Sir. Im from Philippines. Same Problem With Me. To Fix It. In The Formula. Change All , SIGN To This ; one. And No error PopUp. Sorry For My English Hahaha I'll hope It's help You
For those who receive a "Reference isn't valid" error message... Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it. Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
@@ExcelHubPro For those who receive a "Reference isn't valid" error message... Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it. Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
Is there a way to get the image in multiple cells without adding a new name every time? I am having approximately 50 cells where I need to keep repeating the same function. i.e. Every time I go to another cell, I have to copy paste picture in that cell and perform every steps again. Can we do it more faster for multiple rows? Any answer would be appreciated.
I tried to do this but, when I use Indirect function with the cell that I assigned a picture, it returns 0 as in there is no value in the cell that has the picture on it. I am confused as to what I may have done wrong. I tried using both jpg and png type of pictures.
Thanks for video, Leila :-)) It seems to be too complicated.... The only Name you need to use is Flag.... INDIRECT is also not necessary. The Flag formula will be different... it is simply INDEX and MATCH. At the end, you've got one Name only...just Flag. Flag =INDEX(Master!$A$3:$A$8,MATCH($C$2,Master!$B$3:$B$8,0)) This time, INDEX, MATCH is a reference!! :-)))))
Need Help... i completely understood the process however i need to lookup images into new sheet for entire coloum and not the drop down list. can you please help.
Hi Leila, great video. But I am looking for a slightly different solution. Column A, players names. Column B, Logos from where they came from. Column C, the name of that original place. So, column B has to show a logo based on Column C data. And they are more than 500 players so far. And about 60 origin places. That means 60 different logos. Could you help me here, please?
Thank you for your excellent explanation. Sometimes, I don't know why, it does not work and shows the error message: "Reference Isn't valid." Why it happens? How to solve it?
Beware of using this in a workbook with VBA "for" and "with" loops. It seems to slow code execution down by a factor of 11 (eleven)! Remove the linked picture object and you're back to normal speed again. You can verify by re-building the picture object and re-running. Things go back to slow as molasses and almost crashing during execution. I can't figure out exactly whats going on here, but I'd guess a bug. Took months to figure out why macros were running so slow!
I'm having some issues with this working for multiple rows of data, trying to get multiple images. Does this work for what I'm trying to achieve? Trying to put in a green/yellow/red light depending on a status column saying Completed, Not_Started, Ongoing. Thanks!
I love this video. So helpful! but after following all of your step when I type "=Flag" on my its "=display" and click enter I get the following message from excel, " ALERT Reference isn't valid" . What am I doing wrong. I have seriously tried this so many times now and rewatched your video and cant seem to get the images to show. Please Help!
Hi Its Nice. But as per my requirement, I don't need this Dropdown, I simply need vlookup on images means the same way we apply vlookup to extract data in other column but in this case in I need all images in my next column. Is this possible? Please help me with the solution. Thanks in Advance.
I have one big difficult could u pls solve it...I have daily updation of patients names ...I have to check them on daily dates whether they are present are not ...for ex arun is present in 14.07.2020 but vinoth is present in 17.07...the difficult is datewise excels sheets are different excels 14.07.20 one sheet and another 17.07 is another ...of they found I have to go for lookup ...how to solve this pls help me mam
Hi Leila.. I've done this but my excel files become very slow...maybe because i'm using an old pc & around 40 pictures are loading at the same time... any chance to make it load quicker?
Oh my God ! .....what a long video for such a small job. please look into some videos from some Indians. They will teach much more within such time of video. However, a good try
How do you get past the added underscore on a team with two names such as Ivory Coast or New Zealand as it returns in the name manager as Ivory_Coast & New_Zealand??
Hi Leila, my name is Angelo. I'm struggling with a picture lookup for products.i have tried 3 different ways but nothing is working. i need to bring up a barcode of the products from the dropdown . please can you help me.
this is great, but what I need is a function like =image('URL'), similar to the one in google spreadsheets. I can't understand how Microsoft is taking so long to introduce such a powerful formula
![[TH] FS vs BME - VCT Ascension Pacific - Lower Bracket Final](http://i.ytimg.com/vi/wnygqsR2Fig/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/lookup-pictures-file
I think you are perfect. Highly capable, highly intelligent, creative, elegant and also, to state the obvious, extremely beautiful. Thank you for teaching me so much about Excel.
You're very welcome. Thank you very much for the kind words Simon!
Thanks for this! I know it was four years ago but I’m basically on step one. This is so cool and easy to follow. I appreciate the thoroughness ❤️❤️
Awesome! Thank you!
Thank you so much for very clearly demonstrating this function. It works! I used it for a random image picker.
Just one problem I keep getting (please kindly reply/comment if you had a similar problem and/or a solution) - the picture "placeholder" I've used kept duplicating itself, and I end up with many pictures pointing to the same named indirect function, lumping on top of each other. I only noticed their existence because they are sometimes not exactly on top of each other (like not very neatly stacked newspaper where you see the layers sticking out from below), and my file quickly got very big after I used a few of these functions. Anyone had a similar problem?
it's useful. much appreciated, maam
Great learning guide. Excellent teaching style. Thank you!
Glad you liked it!
Can't believe it works! Thanks a million!
Glad it helped
The first time ever i took an excel lesson from outside that was brilliant
Glad to hear that!
@@LeilaGharani Thank you so much Leila
It's bit tricky & lengthy. Your explanation is good, but so much steps To do. I'm sure you will come up with even better hack! 👍🏻😊
Wow - 446k subscribers! Good for you! I've subscribed. Your videos cover so much ground (I just found this little nugget even though I subscribed a while ago), are easy to follow and your depth of knowledge is outstanding! Keep up the great work.
Awesome! Thank you!
Done now, there's any way to include more than one like? Thanks Leila, great teacher!
it blow my mind...
I didn't know this. Thanks for sharing this trick with us
looking your videos and find my self somewhat interested on database!!!!!!
Thank you so much! Very user friendly. Great instructions.
I agree with @frankkneeland as most other tutorials somehow always miss out a tiny but important detail for those of us who are not excel proficient. Thank you Leila.
Awesome - I am Impressed by the picture changing trick 🤠🆒️🤙🏻
Great video Leila! Always something new to learn
You're welcome Luigi.
thanks for the lesson teacher
thanks you
Fantastic Tip My Excel Guru!! I wish safety and wellness during this hard time of Covid-19. Thank you again for this tip, i am using this in my office dashboard. all my udemy subscription of your courses has been the most useful thing for me. so thanks!!! Take care excel guru...!!!!
You are welcome!
Amazing. So clearly explained. Thank you.
First of all I'd like to say that you are looking very beautiful in this video and as you used INDIRECT function in this video that is amazing...🤝?
Great idea
Jesus, Leila! So good!
Learnt something new.. Thank you👍
I know i'm late commenting here, but this video was great and just what I was looking for.
Does anyone know how this can be set up to work on all cells in a column. So where I have a column of options, when one is selected then the corresponding image appears?
This will reduce my work
thank you very much for share your knowledge, very useful
It's my pleasure Mario. Thank you for your support.
Outstanding
Hi Leila, I hope you are well. This is a great video that I have followed to the letter, but unfortunately my end result is #REF. I am using Excel 365, does your solution only work on 2019? My worksheet fails at the =Flag stage and gives me a "Reference isn't valid" error. Is there a simple step that is commonly missed by other people that I may have missed also?
I hope you can point me in the right direction. ***EDIT*** Figured it out - my names in my drop down list data have more than one word, when I named the cells containing the pictures excel replaced the spaces between the words with an "_" . As soon as I changed the names in my drop down list data to be exactly the same (ie with the "_" instead of a space) it worked perfectly. Thanks for a great video :)
Nice one i like it
Hi Leila. I've tried this over and over and OVER again. I have 106 pictures in a column and have followed your video. Most of the pictures change/update as you have shown but some of the other pictures don't. I can't see any reason why this should happen. Any help would be much appreciated. You have an excellent channel. Always my "go to" for anything Excel.
Amazing
I used this trick also, but using index match as a way to look up the picture
👍
Thank you for the video. However, for some reason, linked pictures caused my slicer to be super slow .. Would you help me to solve the problem?
Thank you for the amazing explanation. However does anyone of you knows why the image loses quality when we insert the formula? My images gets pixelated
Love you Leila
Great food, zooms in on flowers lol
Great video. I wish I saw this hours ago. ;)
Glad you like the video.
My students are going to hate me because of now I can generate many sets of questions based on their student IDs. :D Thank you.
Brillant !👍
Genius! Subbed :)
Welcome aboard!
Hi Dear leila
How we can import files from local pc to excel cell?
I can Import from Url but not from Pc.
thanks.
Is there a work around to have the same result but without using the name manager? I would like to be able to do this through Excel's Android app, which doesn't have the name manager feature.
Great
Love this idea. I have been looking for a solution for this. I noticed that it does not seem to work if your right column references are numbers ie - 1 2 3 4 or A B C D?
I need your help Leila. I did a via macro which exports a chart as a picture, save it and then attached in a email (inline html image). Everything works fine, but I can't have control in the picture size and quality. The quality is very poor. I've tried different approaches, but now I'm stocked. Any suggestion? thanks.
Hello Leila,
thank you for educating video, it really helped me to understand VLOOKUP with images.
Is it possible if afterwards we decide to extend list of flags in future (like extension of database) to simple refresh it somehow or all steps must be done from beginning?
Reason for asking is that I would like to have some personal database on one Sheet which should be filled in with new data in future. On other sheet I would like to use your function which should be automatically updated with extension of previously mentioned database Sheet. Possible?
Is indirect more volatile than index match function?
Super, You are Amazing, thanks a lot!
Hello,
Thank you for the video.
I faced some issues. I receive the error #Name? Im not sure where I failed. Before when I did =England in the flag cell it return 0. It might be the cause of it. Any thoughts?
Thanks for the video, how can you do the mulitple flag list? the sample you share it is just one single country.. how can I do with mulitple country
Can the undetected function be used when looking up a drop down list from a search filter formula? Also will it pull images when the names have - or / in them? I was having trouble getting it work? Anyone know? Trying to create a inventory system in excel when you search for a part number it also shows you and image of the part or location.
I am getting error reference not valid in the last. I am following all steps as suggested
Please Leila help me, I tried to do this several times step by step but I don't see the pictures in A1 of the report sheet. it just shows a 0. I tried to use JPG and PNG pictures but that doesn't make any difference. How do you link the pictures to the cell, please?
Hi Leila, everything seems fine till I get to the last step an it says reference not valid
Hi Leila,
thank you for this useful video. I benefitted a lot.
i am struggling with few things though. I am working on a multiple drop down menu and my selections are not unique, for examples the same header might have two different pictures because it depends on the selection before it. is there a way we can make the picture depend on two different drop downs? in my case there is no way of making the headers unique because they are size ranges and those will always be the same for certain features.
I managed to cheat the system by adding spaces when there were no pictures included to make the headers unique, however, this is not working with photos because I have to create a name manager that does not recognize spaces or special characters. can you post a video that has headers that repeat but have different drop downs or provide a formula that allows the dropdown to depend on two lists? or a way to include headers with spaces without showing the "_" in the selection as a space?
Thanks Leila. It is cool. I have a question to ask please. As defining Name in Name Manger, Excel doesn't allow space. To get around, I put an underline in between words of a country name. However, it looks bad in presentation to select the country name with an additional underline. Do we have a get around solution for a better presentation please?
Hi Karen. In that case, all you have to do is to use the substitute function inside indirect. I'm not at my PC now but I provided an example in the comments below here in response to a similar question from someone else. Please have a look.
Hi Leila, does this method work for value in spilled array? Tried the filter formula to get country, then indirect formula in name manager. It only captures the first value and not for the ghosted formula even though it shows the right country. Thanks in advance.
Thanks ... Thanks ... Thanks ...
Thank you for this video.
I need your help I am working in excel2013 and it is not working.
Could you please assist.
What to do incase of merged cells??
Hi how r u? I hope you r good
I have 1 question.
Can we transpose pictures?
I don't know what that means.
If you need a preview for your links: You can use our free screenshot API to securely render an image from any URL of your excel sheet.
how to do it in multiple rows? do i have to it for evvery single row? every single row with unique names? any short cuts?
showing ref. is not valid error while giving =Flag in formula bar
Its a great tools to stores a lot of information like picture . Its work as magic WOW "
Leila Gharani
" shows us the real magic of storing picture
agree - as magic :)
You could have used =offset
Does this method applied to chart as well?
I have not got problem solve about icon flag is not working formula. Please let me explain once again. Leila madam!
How can we insert a picture of specific size from image control of user-form to specific cell of any sheet?
hello Leila! very useful video. i managed to do it however I have small problem. when i choose to save as PDF, the photos don't display when opened with Adobe Acrobat or any other PDF viewer. do you know what might be the problem?
I did it... but an alert showed up. "Reference Isn't Valid"
Sir. Im from Philippines. Same Problem With Me. To Fix It. In The Formula. Change All , SIGN To This ; one. And No error PopUp. Sorry For My English Hahaha I'll hope It's help You
@@bonjoviauriada where we have to change it?
I try the same but ref not valid error alert popup showing
For those who receive a "Reference isn't valid" error message...
Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it.
Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
@@ExcelHubPro For those who receive a "Reference isn't valid" error message...
Instead lf copying the picture itself, copy the cell that contains the image, then paste as linked picture to the destination (use paste special). This will create an image of the source cell along with whatever content that's in it.
Then go ahead and reference the defined name (containing your formula) in the formula bar. Instead of naming each cell then use INDIRECT(), I use XLOOKUP(). The only thing is to make sure that your XLOOKUP() isn't referencing an Excel table, but a defined range (can be the whole column). I have this working with Excel table before but somehow I cannot duplicate that in a different workbook so...
How can i use for multiple cells more than 100. Have to type into each & every cells?
I Love You So Much Thank You
So glad that I have you..
I learned a lot thanks to you..
This was something new to learn, thanks Leila. Btw Beautiful scenery
Is there a way to get the image in multiple cells without adding a new name every time? I am having approximately 50 cells where I need to keep repeating the same function. i.e. Every time I go to another cell, I have to copy paste picture in that cell and perform every steps again. Can we do it more faster for multiple rows? Any answer would be appreciated.
I tried to do this but, when I use Indirect function with the cell that I assigned a picture, it returns 0 as in there is no value in the cell that has the picture on it. I am confused as to what I may have done wrong. I tried using both jpg and png type of pictures.
Having the same problem, dunno how to solve it
Great job. I appreciate. You are a natural born teacher. I owe you.
Thanks for video, Leila :-))
It seems to be too complicated.... The only Name you need to use is Flag.... INDIRECT is also not necessary.
The Flag formula will be different... it is simply INDEX and MATCH.
At the end, you've got one Name only...just Flag.
Flag =INDEX(Master!$A$3:$A$8,MATCH($C$2,Master!$B$3:$B$8,0))
This time, INDEX, MATCH is a reference!!
:-)))))
Thanks to you too Bill Szysz!!!! Always looking for any of your comments :) :)
I look forward to Bill's comments too :)
Ohhh I like the Index Match approach. I'll add this to my video list if you don't mind.
Thanks @John Borg :-)) I don't always have something to say :-))
@MD QUAMARUDDIN, Sorry, i don't know what is the solution of your problem.... but maybe, check if you have got SP3 for office 2007.
@Leila, of course, i do not mind :-)))
What about a straight "If" function?
Need Help... i completely understood the process however i need to lookup images into new sheet for entire coloum and not the drop down list. can you please help.
Hi Leila, great video.
But I am looking for a slightly different solution.
Column A, players names.
Column B, Logos from where they came from.
Column C, the name of that original place.
So, column B has to show a logo based on Column C data.
And they are more than 500 players so far. And about 60 origin places. That means 60 different logos.
Could you help me here, please?
you may use Dget formula
@@cikgumumu5177 - Thank you but I've never heard about it...
@@cikgumumu5177 - Justa tried DGET. This formula can't get pictures. Just gives me a ZERO and nothing else.
@@cikgumumu5177 - Any tip? Please?
Thankyou. I've been struggle with this topic as I don't have Excel 365. No other youtube tutorial helped me but yours.
Thank you for your excellent explanation. Sometimes, I don't know why, it does not work and shows the error message: "Reference Isn't valid."
Why it happens?
How to solve it?
Beware of using this in a workbook with VBA "for" and "with" loops. It seems to slow code execution down by a factor of 11 (eleven)! Remove the linked picture object and you're back to normal speed again. You can verify by re-building the picture object and re-running. Things go back to slow as molasses and almost crashing during execution. I can't figure out exactly whats going on here, but I'd guess a bug. Took months to figure out why macros were running so slow!
you can avoid giving a name for each flag picture
the name Flag, instead of INDIRECT, can be based on OFFSET(MATCH(...))
I'm having some issues with this working for multiple rows of data, trying to get multiple images. Does this work for what I'm trying to achieve? Trying to put in a green/yellow/red light depending on a status column saying Completed, Not_Started, Ongoing. Thanks!
I love this video. So helpful! but after following all of your step when I type "=Flag" on my its "=display" and click enter I get the following message from excel, " ALERT Reference isn't valid" . What am I doing wrong. I have seriously tried this so many times now and rewatched your video and cant seem to get the images to show. Please Help!
Thanks for making us on easy understanding / will these function will work in EXCEL-2007 ???
Hi Its Nice. But as per my requirement, I don't need this Dropdown, I simply need vlookup on images means the same way we apply vlookup to extract data in other column but in this case in I need all images in my next column.
Is this possible? Please help me with the solution. Thanks in Advance.
I have one big difficult could u pls solve it...I have daily updation of patients names ...I have to check them on daily dates whether they are present are not ...for ex arun is present in 14.07.2020 but vinoth is present in 17.07...the difficult is datewise excels sheets are different excels 14.07.20 one sheet and another 17.07 is another ...of they found I have to go for lookup ...how to solve this pls help me mam
Hi Leila.. I've done this but my excel files become very slow...maybe because i'm using an old pc & around 40 pictures are loading at the same time... any chance to make it load quicker?
Oh my God ! .....what a long video for such a small job. please look into some videos from some Indians. They will teach much more within such time of video. However, a good try
Thank you
I discovered that if the cell and the name include blank spaces, the flag does not change.
Thanks a million!
How do you get past the added underscore on a team with two names such as Ivory Coast or New Zealand as it returns in the name manager as Ivory_Coast & New_Zealand??
im having such a problem with staff name.. it returns reference isn't valid
Hi Leila, my name is Angelo. I'm struggling with a picture lookup for products.i have tried 3 different ways but nothing is working. i need to bring up a barcode of the products from the dropdown . please can you help me.
this is great, but what I need is a function like =image('URL'), similar to the one in google spreadsheets. I can't understand how Microsoft is taking so long to introduce such a powerful formula