Autofill if both text criteria are met

[fawn728]

I want to use a formula/function that states if address one is in one column and address two is in the same row in the next column then column 3 should be this number. This is a travel log and I want it to autofill for several offices. So if Washington County and Clinton County are next to eachother the next column should say 26. I need to do that for appx. 12 combination of addresses.

 

[dreid1011]

Sounds like some lookups will be needed. Do you have a table with addresses and numbers already to pull from? Or how are you identifying the number per combination? More information is needed.

 

[fawn728]

Sounds like some lookups will be needed. Do you have a table with addresses and numbers already to pull from? Or how are you identifying the number per combination? More information is needed.

It wouldn't allow me to put the full sheet here but on the table is a column with the distance for each office combination. I am at work and can't download the xlb22 add on to my work computer. The numbers come from a program we use to reimburse mileage.

 

[dreid1011]

It wouldn't allow me to put the full sheet here but on the table is a column with the distance for each office combination. I am at work and can't download the xlb22 add on to my work computer. The numbers come from a program we use to reimburse mileage.

Okay, well you can either take another screenshot of that table/column or reply with a small sample in table form as closely to your actual data as possible. Or upload the book to onedrive, google docs, etc.

 

[fawn728]

Okay, well you can either take another screenshot of that table/column or reply with a small sample in table form as closely to your actual data as possible. Or upload the book to onedrive, google docs, etc.

Okay, well you can either take another screenshot of that table/column or reply with a small sample in table form as closely to your actual data as possible. Or upload the book to onedrive, google docs, etc.

 

[fawn728]

The office location names are shortened and not every row is somewhere we consistently travel. I only want it to autofill for the addresses we go consistently. Would it help to have the complete addresses in column N?

 

[dreid1011]

Is it possible to have the starting location in one column and the ending location in another?

 

[dreid1011]

The office location names are shortened and not every row is somewhere we consistently travel. I only want it to autofill for the addresses we go consistently. Would it help to have the complete addresses in column N?

The most ideal setup would have the starting location in 1 column and the ending location in the next column with the distance in the third column. And at the very least, the most frequent combinations, if not all.

 

[fawn728]

The most ideal setup would have the starting location in 1 column and the ending location in the next column with the distance in the third column. And at the very least, the most frequent combinations, if not all.

 

[fawn728]

Separated like this?