can i use vlookup in my form attached

Dear Experts
Please check my atached file and my question posted in the file.

thanks

In B5 Cell of Extract Sheet

=VLOOKUP($B$3,data!B:E,ROW(2:2),0)

Drag it down....

Enter Reference No in B3 Cell.

Dear Sixthsense
thats fine.
but i need picture in B4. the formulae you given does not extract picture from data sheet. please revise.
thanks

Go through the below link and download the Tips File from Post #1 and refer Sheet Name 55 to know how to do it

http://www.excelforum.com/tips-and-t...learned-7.html

Dear,
I checked from your tips file. its nice but i am not enough expert to apply your logics on my sheet. so if you please do this for me on my sheet.

Reattaching file

thanx a lot.

Roofi

What is your exact excel version?

Me too facing some problem when I open the file in Excel 2003 version.

The picture is not loading after changing the different value from the DropDown List.

But when I open it in excel 2010 version then it is working fine. But After selection I need to move the cursor to the Picture located cell then only the picture is changing

I will call all members help for this

Dear

i am using excel 2007. please revise. thanx

Open the Post #7 attachment file and check and confirm whether its working for you

Dear
Me too facing some problem when I open the file in Excel 2007 version.

The picture is not loading after changing the different value from the DropDown List.

please revise
thanx

@ azumi,

Your Post #11 attachment file is working fine and I am totally confused and unable to find what I missed in my file

Dear Azumi
Great!
its working now. still one thing to be update.
i neeed the same picture in the same sheet also in C1 in large size. as attached.
please revise.
thanx

@ azumi,

Thanks for the link I will check it after since I can't access that link because of restriction

Dear Azumi and Sixthsense,
thank you both. my problem solved.
thank you very much

@Sixthsense,
The picX formula is incorrect because you have used a relative row number in MATCH part not absolute. It must be MATCH(extract!$B$3,...

@ Izandol,

Thanks a lot for letting me know my mistake, yes you are right... I used relative reference and I never thought it requires absolute reference.

Another error is in that file I referred to extract!$B2 cell instead of B3.

If you don't tell my mistake then I have not realized what I did wrong.

Once again thank you