Hi Experts.
I hope you all would be fine and doing great.
I just needs to know how I can pull picture which is placed in-front of any value e.g. We pull some data through vlookup formula but here i want to know we can pull picture which is placed in-front of any value.
I have attached 2 workbooks here.
1: Data
2: Result
Here is link of files.
https://www.dropbox.com/s/vg1wkdf965l43xu/Result.xlsx
https://www.dropbox.com/s/g1lgsgc5sseyoqy/Data.xlsx
In Data workbook there are 2 sheets Named New and Old.
What i am trying to do is, If we enter a name in CELL "C3" in "Result" workbook then it lookup that name in data workbook in both sheets of DATA (NEW/OLD) then if lookup found same name in any sheets then it must pull pic infront of cell which contain desired value and placed picture in result sheet on C4 cell and re size pic according to the size of C4 cell.
Both file are placed in same folder.
I have no idea how to deal with such issue, Please assist if possible.
Thank's in advance.
Regards,
Smith
I hope you all would be fine and doing great.
I just needs to know how I can pull picture which is placed in-front of any value e.g. We pull some data through vlookup formula but here i want to know we can pull picture which is placed in-front of any value.
I have attached 2 workbooks here.
1: Data
2: Result
Here is link of files.
https://www.dropbox.com/s/vg1wkdf965l43xu/Result.xlsx
https://www.dropbox.com/s/g1lgsgc5sseyoqy/Data.xlsx
In Data workbook there are 2 sheets Named New and Old.
What i am trying to do is, If we enter a name in CELL "C3" in "Result" workbook then it lookup that name in data workbook in both sheets of DATA (NEW/OLD) then if lookup found same name in any sheets then it must pull pic infront of cell which contain desired value and placed picture in result sheet on C4 cell and re size pic according to the size of C4 cell.
Both file are placed in same folder.
I have no idea how to deal with such issue, Please assist if possible.
Thank's in advance.
Regards,
Smith