regexgoogle-sheetsgoogle-sheets-formulavlookuptextjoin
If cell contains a certain text, return a specific drop down list item (Google Sheets)
I've created a quote form, and in one cell (C6:H9) I enter the address with the city name.
In another cell (C31:F31), I have a drop down list with different city names and when a city is chosen from the drop down list, it displays a certain percentage number in another cell beside it (G31), which is the tax pertaining to that city.
I'm trying to figure out how to get the drop down list cell (C31:F31) to return an item on the drop down list if a certain city text is typed in the address cell (C6:H9).
But I'm having a hard time figuring out how to do so.
Solution
try:
=IFNA(VLOOKUP(VLOOKUP(REGEXEXTRACT(C6,
TEXTJOIN("|", 1, 'Tax Rates'!E3:E)), 'Tax Rates'!E3:F, 2, 0), 'Tax Rates'!A3:B, 2, 0))
update:
=IFNA(VLOOKUP(IFERROR(VLOOKUP(REGEXEXTRACT(C6,
TEXTJOIN("|", 1, 'Tax Rates'!E3:E)), 'Tax Rates'!E3:F, 2, ),
REGEXEXTRACT(C6, TEXTJOIN("|", 1, 'Tax Rates'!A3:A))), 'Tax Rates'!A3:B, 2, ))
- Match specific length x or y
- Get first three words from up to 10 comma-delimited phrases in a string
- mysql update with regexp
- Match any time in the ISO 8601 format between 06:40:00 and 06:59:59 am (UTC)
- Regex backreference not returning anything?
- Perl search and replace words in file
- Why do negated character classes in JavaScript Regular Expressions traverse newlines even with multiline mode disabled
- Regex: matching up to the first occurrence of a character
- Extract BBEdit search history into a shell script
- Regex for telegram-like username
- Is there a ReSharper annotation for regex highlighting?
- How do I use re.search starting from a certain index in the string?
- How To Use Regex in Powershell to replace all but first character of a match
- Unable to group parts of the regex together to make the intended operator precedence explicit
- Regex match all words but not in quotes and not list of words
- Splitting string from the first occurrence of a character
- Regex matching with ASCII and extended Unicode characters
- jQuery - JavaScript regex allow only numeric and minus sign as first character
- Calculate the string length in sed
- Javascript Regular Expression Not Failing When I Think It Should
- error when executing regular expression with python
- How to replace text using a regular expression in bash
- Regular expression and sed to remove all occurences of some string from hundreds of files
- Using Regex to generate Strings rather than match them
- How to evaluate a when condition for Ansible task
- Simple Find and Replace Text in Sublime Text Using REGEX
- Regular expression to stop at first match
- Intellij HTML Tags Find usage with filter
- JEXL expression to match with an array of regex?
- C# Regex for Guid