Hi, I'm trying to use 'ignore_case' in my formula, reference from other discussion boards which is

Syntax

Lookup(source_column,lookup_table,matching_column,replacement_column[,leave_original_value][,replace_nulls][,ignore_case])

but, it seems that mine doesn't work.

Thing is, in the current table and Labor List Table's FName, there are second names that is written in 'First_Letter_Caps' rule, while some aren't.

What should I do with this?

I didn't even know that ignore case was something that was possible! 

The way I've always got around issues with case is by either creating two columns that are copies of the originals that are UPPER. So in the area you are looking up from, and looking up to, create an Upper FName column by writing =UPPER(FName), then lookup between these two as they will all be in uppercase and should completely match. Then you would just type =Lookup(Upper FName, Labor List, Upper FName, Last Name)

Hope this helps!

I've been doing the same thing and had no idea about the ignore case function!  Going to give that a whirl.  Halfway thought of changing everything coming in from external sources to lowercase only bc inevitably I'll write a formula to accept their uppercase results, and then later on, they'll change it to lowercase and not tell anyone.  In some cases, too, I'll use Find instead of typing the results out the way they send them (since they like to change things so much ha).

I agree with Oli's approach to this. I've been using ignore case for some time, but find that it's more consistent to create an Upper Case version of label columns, especially when it involves lookups.

Hi @Camille Faith Crisostomo,

Here is some description on ignore_case:

ignore_case

A boolean value (true or false) that controls whether the lookup ignores case when comparing values from the source_column to the matching_column. If ignore_case = true, Lookup ignores case; if false, Lookup is case-sensitive. If this argument is not specified, it defaults to false. The Lookup operation will be faster when ignore_case is false, so only change this when needed.

So, you need to use "true" instead of [,ignore_case] in your formula. Could you please try that and see if that works?

Thanks,

Gulcin

Hi Camille,

You'll need to provide responses to each of the boolean values for everything to work correctly for ignore case.  I believe the following formula should work based on what you originally listed.

• =lookup(FName,Labor List,FName,Last Name,false,false,true)

The third Boolean value of 'true' will allow you to ignore case on the lookup comparison.

-Brian

It works now, thanks!