Forum Discussion
Need help creating a formula using certain data from two sheets within a workbook
I am trying to calculate what portion of a refund would be sales tax refund only using data from two sheets within a workbook. First I have the match the zip code (column I) from sheet 1 (refunds) t...
Thank you so much for your response.
Is there a way to tie the name of the city on sheet 1 (refunds) to any zip codes that have multiple "StrTotalTaxRate"?
Is there a way to tie the name of the city on sheet 1 (refunds) to any zip codes that have multiple "StrTotalTaxRate"?
=VLOOKUP(I2&H2,CHOOSE({1,2},CompliSalesTaxRates!$A$2:$A$80602&CompliSalesTaxRates!$E$2:$E$80602,CompliSalesTaxRates!$I$2:$I$80602),2,FALSE)*E2
This formula ties zipcode and city togehter no matter if there are multiple StrTotalTaxRates for a zipcode. Enter formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Sometimes formula returns #NA because no exact match is found. For example in row 64 "Wildwood crest" is entered with 3 spaces. In row 263 " Slidell" is entered with a space in the beginning.