Move Signature Block Formula with airSlate SignNow

Add conditional fields, Change Pictures to black and white and eSignature

in today's video I'm going to show you how you can do lookups on pictures now I'm filming this from Majorca in Spain it's a very nice island in the Mediterranean Sea with spectacular views and beautiful scenery you get to see the hills cute little villages and great food there talking about pictures in the previous video we saw an example of the picture look up in the FIFA World Cup tool that visualized the countries which made it to the round of 16 then quarter-finals and so on now if you missed that video I'm gonna put a link to it in the description below the video now what was great about that visualization is that when the country changes the flag updates accordingly now there's no VBA here it's just smart use of Excel features now the best thing is that you can use it for different purposes you can use it for employee pictures you can use it for sales managers business unit or company logos now anywhere where you need to do lookup on pictures this technique comes in handy so let me show you how you can set this up on this sheet I have a list of sample countries along with their Flags organized like this where the aim is to create a drop-down list on the report tab right here where I'm going to be selecting the country and on top of my report here I want to see the flag of the country that I selected so my first step is to organize my images in the proper way and the proper way is that each single image should sit inside a cell I mean sitting on top of the cell but it should be surrounded by the cell and it should be right beside the correct text in our master data now one thing I do here is to click on any of these images and then press ctrl a to select all the remaining images then I'm going to press ctrl one to bring up the properties and I'm going to go to the prop tab right here and select don't move or size with cells this makes sure that if I change the row height of any of these that my image is not going to stretch now the next thing to do is to make sure that they all have the same row height and that the roll is big enough for the image to fit inside it so I'm just gonna right mouse click go to a row height and just go with 16.1 I think that will fit my images so this image does fit well here now the next thing I need to do is to make sure each of these single images is going to be inside its own cell so I'm gonna bring Australia up to where I want it and then use ctrl a to mark all of them then go...