Creating a formula

  • Thread starter Thread starter GAW
  • Start date Start date
G

GAW

I am working on a spreadsheet; in the spreadsheet I have a column for a
county, a column for a service, in the next column I would like to pull the
information from a table which match the first two columns. The third column
will be a drop down list. Is there a formula I can use to create this in
Excel 2003.
 
--The below formula will return the entry in column C which match the
criteria ColA =D1 and ColB =D2
=INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=D1)*($B$1:$B$10=D2),0))

--If you are looking at dependent lists then check out the below link by
Debra Dalgleish

on the subject "Excel -- Data Validation -- Dependent Dropdowns from a
Sorted List "
http://www.contextures.com/xlDataVal13.html

"Excel Data Validation -- Create Dependent Lists"
http://www.contextures.com/xlDataVal02.html

If this post helps click Yes
 
Back
Top