Vlookup for different sheets

[lece]

Hello!

I am looking for a formula that will look into other sheet values and give me the dropbox options according to those values. It is hard to explain so I have attached an example.
So, when I type the supplier name in 'Form' B1, the list of products/services supplied by that supplier will appear in B3 as a dropbox to choose from (data is in 'Data').

Thanks

[menem]

Pleaset try this formula in data validation of cell B3

Please Login or Register  to view this content.

This formula is need sorted data (supplier name) as your example.


Regards.

[lece]

Thanks! I've just tried but it gives only one entry (repair) for supplier A, instead of the drop down list with the 3 options for supplier A: Calibration, Repair, Sales.

Any other ideas?

[menem]

Please review from the file.



Regards.

[lece]

Thanks! one last question to clarify it, is the B1 after Match referring to Form sheet? and the last one to Data sheet?

=OFFSET(Data!$A$1,MATCH($B$1,Data!$A:$A,0)-1,1,COUNTIF(Data!$A:$A,$B$1))

Thansk!

[menem]

All are refered from DATA sheet , except (both) B1 is refered from Form sheet.

Regards.

[lece]

It works perfectly!! Thank you for your help!!!