Tag Info

New answers tagged


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