In a Google Sheets workbook, I have a sheet named Tax Codes and Rates containing a tax table with the following 4 columns: County ,  Municipality or County ,  Location Code ,  Rate

Sample Lookup Data

^{Sheet: 'Tax Codes and Rates'}

In a separate sheet named DA Template, I want a formula that takes a Location Code as input and returns the Rate from the matching row in the Tax Codes and Rates sheet.

Sample Results

^{Sheet: 'DA Template'}

Using the sample tables above,

1. Lookup value 05-005 located in 'DA Template'!A2 matches 'Tax Codes and Rates'!C5'
2. Formula in 'DA Template'!B2 returns 6.00% the value from Rate in the same row: 'Tax Codes and Rates'!D5'

What formula would automatically return the Rate based on the Location Code?

Sample Google Sheets Workbook

In a Google Sheets workbook, I have a sheet named Tax Codes and Rates containing a tax table with the following 4 columns: County ,  Municipality or County ,  Location Code ,  Rate

Sample Lookup Data

^{Sheet: 'Tax Codes and Rates'}

In a separate sheet named DA Template, I want a formula that takes a Location Code as input and returns the Rate from the matching row in the Tax Codes and Rates sheet.

Sample Results

^{Sheet: 'DA Template'}

Using the sample tables above,

1. Lookup value 05-005 located in 'DA Template'!A2 matches 'Tax Codes and Rates'!C5'
2. Formula in 'DA Template'!B2 returns 6.00% the value from Rate in the same row: 'Tax Codes and Rates'!D5'

What formula would automatically return the Rate based on the Location Code?

Sample Google Sheets Workbook

I would like a field to auto-populate when I select data from another field. I understand I could do this with an "IF" function.

However, the data from the initiating field is a long list filled via data verification. If I select an item from the first list, I would like it to populate with the corresponding number from the adjacent field.

Sample Sheet

For example: Using Data Verification, 'Template"!A2 is populated with the list from 'Tax Codes and Rates' Column A. If I select 05-005 (which is 'Tax Codes and Rates'!A23) is there a formula that would automatically 'Tax Codes and Rates'B23?

In a Google Sheets workbook, I have a sheet named Tax Codes and Rates containing a tax table with the following 4 columns: County ,  Municipality or County ,  Location Code ,  Rate

Sample Lookup Data

^{Sheet: 'Tax Codes and Rates'}

In a separate sheet named DA Template, I want a formula that takes a Location Code as input and returns the Rate from the matching row in the Tax Codes and Rates sheet.

Sample Results

^{Sheet: 'DA Template'}

Using the sample tables above,

1. Lookup value 05-005 located in 'DA Template'!A2 matches 'Tax Codes and Rates'!C5'
2. Formula in 'DA Template'!B2 returns 6.00% the value from Rate in the same row: 'Tax Codes and Rates'!D5'

What formula would automatically return the Rate based on the Location Code?

Sample Google Sheets Workbook

I would like a field to auto-populate when I select data from another field. I understand I could do this with an "IF" function.

However, the data from the initiating field is a long list filled via data verification. If I select an item from the first list, I would like it to populate with the corresponding number from the adjacent field.

Sample Sheet: https://docs.google.com/spreadsheets/d/1x4GhIv4ptDkM-IpfdtLH2cFtfKk5gzYTYo4ETKhY68Y/edit?usp=sharing

For example: Using Data Verification, 'Template"!A2 is populated with the list from 'Tax Codes and Rates' Column A. If I select 05-005 (which is 'Tax Codes and Rates'!A23) is there a formula that would automatically 'Tax Codes and Rates'B23?

Thanks!

I would like a field to auto-populate when I select data from another field. I understand I could do this with an "IF" function.

However, the data from the initiating field is a long list filled via data verification. If I select an item from the first list, I would like it to populate with the corresponding number from the adjacent field.

Sample Sheet

For example: Using Data Verification, 'Template"!A2 is populated with the list from 'Tax Codes and Rates' Column A. If I select 05-005 (which is 'Tax Codes and Rates'!A23) is there a formula that would automatically 'Tax Codes and Rates'B23?