IF/AND Please help!!

Jamie1414

I am trying to have submissions from a form auto populate the payment type based on the vendor for the item. Please see below.

Vendor column name is Vendor

Augusta Medical Systems - "CC"
Benova - "Net30"
Comfy Chemo - "CC"
FullScript - "CC"
Good Clean Love - "Premier"
Horizon - "Net30"
Lymphedema Products - "CC"
Medicine Mama - "CC"
Miaderm - "Net30"
Ohnut - "CC"
Plus One - "CC"
Premier - "Premier"
Soul Source - "Premier"
Squatty Potty - "CC"
Turban Plus - "CC"
Uberlube - "CC"

Paul Newcome

My suggestion would be a second reference sheet with a two column table. One is the vendors and the other is the payment types. Then you would use a formula along the lines of

=INDEX({Table Sheet Payment Type Column}, MATCH(Vendor@row, {Table Sheet Vendor Column}, 0))

Paul Newcome

My suggestion would be a second reference sheet with a two column table. One is the vendors and the other is the payment types. Then you would use a formula along the lines of

=INDEX({Table Sheet Payment Type Column}, MATCH(Vendor@row, {Table Sheet Vendor Column}, 0))