Display multiple fields in drop-down list, return single value

[jwuj97f]

I am stuck, have a table with [ID, Fname, Lname, Amount].

Need to create drop-down list showing [ID, Fname & Lname]; ID be returned to be used in other calculations.

Is this possible in Excel or VBA?

 

[Yongle]

You could add a column to your table to concatenate the 3 values and use that as the dropdown list
- concatenate in a way to make column values line up (if required)

Are IDs a consistent length? (alpha? Numeric? Leading zeros?)

 

[jwuj97f]

You could add a column to your table to concatenate the 3 values and use that as the dropdown list
- concatenate in a way to make column values line up (if required)

Are IDs a consistent length? (alpha? Numeric? Leading zeros?)

I achieved the desired result by adding a field to the end of the table; which identified the unique dates.

=SUM(IF(COUNTIF(A$3:A4,A4)<>1,0,COUNTIF(A$3:A4,A4)),BM3)

This formula worked really well. all I had to do was assign a name to the range, then use the = MAX(name) to get the max number unique values. then assigned the formula to dropdown list validation.

Thanks for your help