Tag Info

New answers tagged

1

Use =vlookup. Say your names are in ColumnA of Sheet1, with corresponding details in ColumnsB:C. In a different sheet ColumnD (assumed to be where the validation takes place) with names can be matched with the corresponding details with a formula such as: =VLOOKUP($D1,Sheet1!$A:$C,2,false) copied across to the right (with 2 there changed to 3) and ...



Top 50 recent answers are included