Auto Populate a Data Validation Table

[AnnaMary1234]

I am working on a quoting template and since some Vendors have multiple contacts I am trying to figure out how I can select a vendor and then in the 'Contact' spot have a data validation table auto populate with all the contacts for that one specific vendor ( there is about 1,000 different vendors and each one has 5+ contacts so having it more specific would be ideal) and help would be greatly appreciated!!!

 

[RAJESH NATH]

VENDOR	CONTACT 1	CONTACT 2	CONTACT 3	CONTACT 4	CONTACT 5
A	99​	98​	48​	36​	24​
B	34​	37​	38​	39​	40​
C	41​	42​	43​	44​	45​
D	46​	47​	49​	50​	51​
E	52​	53​	54​	55​	56​

result

D

46​

47​

49​

50​

51​

for data validation click on DATA>Data validation>select criteria (allow list)>select sources.

Sources column will be vendor column.
Then use formula next cell using data validation.
=INDEX(B$3:B$7,MATCH($H$3,$A$3:$A$7,0))

 

[AnnaMary1234]

i'll give this a try, thank you !