How to use Excel VLOOKUP function with words that begin with the letters AB

0 votes

For title naming, I have a list of words that I employ. As I come up with new names, I want to make sure I'm not using words that have already been used. When I encountered terms that start with the letters AB (such as absolute, abolished, etc.) that I had never used before, my Excel formula appeared to be operating as intended. 

=IF(VLOOKUP(B48,Used!A:A,1)=B48,"USED","")
New Word Result Formula Commentary
Pretend ...VLOOKUP(B48,Used!A:A,1)=B48 correctly returns FALSE because it did not find the word
Abundant USED ...VLOOKUP(B48,Used!A:A,1)=B48 correctly returns TRUE because it did find the word
Absolute #N/A ...VLOOKUP(B48,Used!A:A,1)=B48 returns #N/A when it does not find any word that begins with AB

I've tried using the TEXT function in the formula to format B48, but no change. I've tried using Range_Lookup in the VLOOKUP syntax, but no change.

Any help would be appreciated.

Nov 24, 2022 in Others by Kithuzzz
• 38,020 points
1,366 views

1 answer to this question.

0 votes
If you lookup "AB" in Excel, it does not search for a value that starts with it, but for a value that equals it. If you want to lookup any word starting with "AB" you have to tell Excel by adding a wildcard: =VLOOKUP(B48&"*",Used!A:A,1,0)

I hope this helps you.
answered Nov 24, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

answered Jan 13, 2023 in Others by narikkadan
• 63,720 points
583 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,720 points
945 views
0 votes
1 answer

how to show the <meta> values of yoast seo with some function?

check this folder : wordpress-seo\src\presenters\open-graph you can ...READ MORE

answered Feb 10, 2022 in Others by narikkadan
• 63,720 points
554 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,720 points
3,720 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,720 points
3,457 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

The syntax for VLOOKUP is VLOOKUP(Lookup_Value,Table Array,Col_index_num,Range_lookup) OR, to start in ...READ MORE

answered Sep 30, 2022 in Others by narikkadan
• 63,720 points
947 views
0 votes
1 answer

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

answered Oct 16, 2022 in Others by narikkadan
• 63,720 points
995 views
0 votes
1 answer

Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 63,720 points
488 views
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
814 views
0 votes
1 answer

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

answered Nov 13, 2022 in Others by narikkadan
• 63,720 points
489 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP