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 790 views

## 1 answer to this question.

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.
• 63,420 points

## 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

## 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

## 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

## 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

## 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

## Convert three letter country codes to full country names

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

## Using VLOOKUP()

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