Require combine Formula which involve Vlookup & Drop Down

Dear All,

I require Formula which is show the Formula which combine Vlookup & Drop Down for my file?? In my File I have FID & Variety Code. Variety Codes are same & but FID are different. Some FID have multiple Variety Codes (example : FID 91 has two Variety Code). in working File i want to insert the formula in G coloum in Receiving material. i want to pick Variety code from sheet 3 or sheet 2 using Vlookup.

Fid. Variety Code
91 5009
91 5036
92 TC-1
99 5009
99 5083
141 5012
141 5108
144 5001
144 5108

Why not use:

=IFERROR(VLOOKUP(C3,Sheet2!A:B,2,FALSE),"")

Dear Glenn,

Thanks for prompt Reply ... Problem is there in vlookup it will pick the only First number. Suppose FID 91 has 2 variety code (5009, 5036) if i apply Vlookup Normal it will always pick 5009 as variety as first pick up ... and i will never know what is other variety code laying in hand of FID 91.

that by i need vlookup with dropdown so data can manage and i can pick the value which i want

There is no practical way of achieving this, over large numbers of rows, with an Excel formula. One workaround might be as here: prepare a list of concatenated FID/varieties in ONE dropdown and then use a formula to separate FID from variety.

If thta does not work for you... then you will need VBA.