Photo automation from one sheet to another sheet

[kamaruddinjnv]

	A	B	C
1	ROLL NO	NAME	IMAGE
2	1	AKASH
3	2	SAKHI
4	3	MAHIMA
5	4	ARJOO
6	5	SAHIL

<tbody>
</tbody>

SHEET-2

	A	B	C
1	ARJOO	4	IMAGE OF ARJOO
2

<tbody>
</tbody>

I WANT TO AUTOMATICALLY INSERT IMAGE ON SHEET-2 IN C-1 FROM SHEET-1 COLUMN -C . SHEET-2, B-1 ROLL NO IS CHANGABE. I TRIED IT BY USING INDEXAND MATCH FORMULA VIA NAME MANAGER ( LIKE THIS-=INDEX(Sheet1!$B$2:$B$5,MATCH(Sheet1!$D$2,Sheet1!$A$2:$A$5,0)). IT WORKS FOR SHOWING ONLY. WHEN I GO TO PRINT PREVIEW OR PRINT ITS NOT PROPERLY PRINT. HALF IMAGE CAME FROM ROLL NO UP AND HALF IMAGE PRINT ROLL NO DOWN.
IS ANY VBA CODE FOR THIS OR ANY OTHER FORMULA EXCLUDING INDEX AND MATCH FUNCTION IN NAME MANAGER.

WAITING FOR HELP.

THANKS IN ADAVANCE.

 

[yky]

Images are stored on another layer. They don't belong to any cells. I wonder why your formula even works.

 

[ttray33y]

i don't think you can store images on a cell, I know its there but it's not residing to any cell. You can however insert a comment on a cell and format it to picture (image). now you can copy and paste the same comment(image) to another cell.