Forum Discussion
Data validation with multiple columns
Hello all I work for a medical centre in australia and do all the ordering, I use an excel spreadsheet to enter all the data but it is very time consuming, I want to use data validation from a dr...
As Hans shown in his answer, how to pull price by selecting name of item, is it what you want or something else?
Additionally INDEX/MATCH will also work in all version of Excel.
=INDEX(G:G,MATCH(C5,F:F,0))