Hi, does anyone know of a way to use a vlookup or countif on a picklist that displays two columns, in a picklist as I want to be abe to pick from a list that containes surnames in one column and first name on the next as the list i have has alot of names the has for example: Smith , adam, brian charles,
using a combination of data validation but to display the content of to columns/rows instead of one and
=IF(COUNTIF(AllCompanies,$A3)<>0,VLOOKUP('Data Sheet'!$A3,AllData,3,FALSE),"")
using a combination of data validation but to display the content of to columns/rows instead of one and
=IF(COUNTIF(AllCompanies,$A3)<>0,VLOOKUP('Data Sheet'!$A3,AllData,3,FALSE),"")