still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 814
- Office Version
- 365
- Platform
- Windows
Hi
I have a table of names
A1:A100 = first names .. ( lower case)
B1:B100 = last names ... (upper case)
F1 = the first name I'm trying to match up .. (lower case)
I’m using a Filter Function because I have multiple same first names
The problem is if I type in the first name in F1, I get “not found”
If I copy and paste the same first name from the table, I get the last name (s)
I don’t understand it
mike
I have a table of names
A1:A100 = first names .. ( lower case)
B1:B100 = last names ... (upper case)
F1 = the first name I'm trying to match up .. (lower case)
I’m using a Filter Function because I have multiple same first names
Excel Formula:
=FILTER(B1:B100,A1:A100=F1,"not found")
If I copy and paste the same first name from the table, I get the last name (s)
I don’t understand it
mike