google-sheets
If a cell contains a value from a list, return the value of the cell adjacent to the list
I have a list of racing codes, and those codes can be sorted into 3 Groups (Flats, Harness, Jumps). If the Racing Code contains either "Pace or "Trots" then it is in group "Harness". If it contains either "Chs" or "Hrd" then it is in group "Jumps". If it contains niether of those four words, then it is in group "Flats". I want to create a formula that searches a list containing (Pace, Trots, Chs, Hrd) and then return the value of either Jumps or Harness, and if it doesn't match returns Flats. I've linked a Google Sheet. https://docs.google.com/spreadsheets/d/18m9rZRpBvan36-4LR2KqWdLtztNZOlljAWICFtMqqAE/edit?usp=sharing
I have googles and watch videos using IF, OR and SEARCH functions but can't adapt either to my situation and make it work.
Solution
=map(A2:A,lambda(Σ,if(Σ="",,iferror(+tocol(map(D2:D,E2:E,lambda(d,e,if(d="",,if(regexmatch(Σ,"(?i)\b("&d&")\b"),e,)))),1),"Flats"))))
- How to Show/Hide rows in google sheets using a script?
- Popping a Modal Dialog when changing the drop down entry in Google Sheets
- Transfer background color from cell range to drop down options
- How can I match a smart chip using SUMIF?
- List Google drive folder contents to google sheets with only new files
- Trying to figure out why my GoogleSheets Date formula is not working
- Google Sheets Row Number of last row in a defined table
- How can I use INDEX and MATCH along with conditions to filter data into different tables?
- Google Sheets formula to remove all punctuation excluding period (.)
- Formula to find missing serial numbers
- Google Sheet Vlookup Multiple Criteria
- Copy Data from one column and past at the end of another column
- Query formula not grouping properly
- Comparing text fields that contain dates in Google Sheets
- Signature Pad (Canvas) to Google Sheets
- regexreplace multiple columns for football data
- I want to use a macro to check a value in a sheet and return one of two values
- How can I remove consecutive duplicates from a range in Google Sheets?
- Using FILTER with multiple conditions on Google Sheet
- How to union ranges in google spreadsheets
- Google Sheets Dynamic Dropdown List Dependent with multiple rows
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- How to use Apps script to move a lot of data rows at same time to different spreadsheet automatically base on time
- How to ignore empty rows when submitting to database
- Custom Menus Google Apps Script
- Google Sheets Index Sidebar of all tabs - add search functionality
- How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
- Google script Display array with rows of different sizes
- How to Delete Today's Google Calendar Entries in Google Apps Script