Hi everyone,

Let's say i have a spreadsheet with a column of:
NAME SURNAME PASSPORT NO.
kelly
cheryl

i then have another spreadsheet containing the details:

SURNAME PASSPORT NO.
lim 123456
liew 789123

i then create a drop down list from another spreadsheet consisting of
"kelly" & "cheryl", what ways can i do or link?? when i select on "kelly" and
on the first spreadsheet, the next column would appear the details itself-
lim (surname) 123456 (passport no.)

Hope to hear from you soon.
Thank you

Warmest Regards,
Kelly