Vlookup and dependant data, please help

Hello,

a few times people helped and it's really valuable, need your help further, would appreciate really much if somebody could help me out.

What i have is:
Different sheets which have equipments lists with name, s/n and value. I want to make
semi automatic invoice, so that from the drop down menu i select category of the
equipment, then accordingly i get lists from those sheets again in the drop down menu, then i select specific model and s/n , price fills in automatically.

Attaching the file for easier understanding,

thank you very much!
Tomas

This link should put you on track

Yep, but it's only a part, it does show drop down lists from selected groups, but i still need some data to be input automatically according to the selection from the drop down menu...

Then try this link

I am sure you must be knowing how to do dependent validation to columns B and C in the sheet "invoice"
once you do it see the formula in D5 in the same sheet. I have copied this formula in E5 also

now in B5 choose the equipment form the dropdown box camera or lens
in C5 depending upon what you chose in B5 the dropdown box will differ and choose anyone of them.
automatically D5 and E5 are filled.

I am returning the file now called excine.xls

do not choose wrong dependent validations.