Drop down reference

[esupply]

Afternoon everyone, have a question, Im trying to work on a dropdown reference, i want to be able to type a number in a cell and them in another box i want to choose from a drop down selection of what i want to choose. I have gotten it close to working but it keep either giving me a REF# code or a zero, can some one take a look at the attached sheet and give some insight. Thanks

[DonkeyOte]

Do you mean perhaps:

Please Login or Register  to view this content.

[esupply]

This is not the first time you have solved my issues ,,,thanks alot man, I was just missing the sheet2 Ref i was thinking i had t oput that in there but i wasnt to sure where to put it,,,,Awesome

[DonkeyOte]

In addition to your point re: Sheet2... one of your Match functions was also using a match_type of 1 (TRUE) rather than 0 (FALSE - exact match) which would have caused issues...