vlookup

[lauro]

Hello everybody,
I have a sheet (ULD) where I input some data in 4 columns. In column A I have numbers (kgs). There can be some duplicates. The difference will be made by what is in column B. In sheet A/C in cell A1 I input the kgs and in B1 the formula reads "=vlookpup(A1;ULD!A1:D5;2)". The problem is that if I input a weight that has a duplicate the formula will return always the same result. Is there a way to get a userform showing all duplicates (all 4 cells), select the 1 that I want and get the value in the right place?

hope this make some sense

Thank you all

[zbor]

Upload example workbook with your input and desired output

[lauro]

Hello Zbor, attached please find Book1.

As you can see in AC all 1850 (A22, D22; G36) give the same result in A21, D21, G35. But if you look in ULD you can see that I have 3 different options for 1850. I would like, for example, G35 to have 00494. Is there a way to create some sort of userform that contains all available options (in this case I have 3 times 1850, say I use 00494 for G35, 2 are left, when the userform re-appears it should show only the 2 options left).

thank you very much