Lookup formula to populate a column based on a name search/match in another table

If you take another look at that example I’ve altered it so it ignores case. No need to change the data in Goggle Sheets. :slight_smile:

/edit - it’s an age-old trick used in programming: just convert both strings you’re comparing to lower (or upper) case before the comparison. :wink:

2 Likes