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.

3 days ago in Others by Kithuzzz
• 20,660 points
10 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 3 days ago by narikkadan
• 37,660 points

Related Questions In Others

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 in Others by narikkadan
• 37,660 points
124 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 in Others by narikkadan
• 37,660 points
175 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
44 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer
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 in Others by narikkadan
• 37,660 points
61 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 in Others by narikkadan
• 37,660 points
47 views
0 votes
1 answer

Using VLOOKUP()

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

answered Nov 5 in Others by narikkadan
• 37,660 points
28 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 in Others by narikkadan
• 37,660 points
66 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 in Others by narikkadan
• 37,660 points
23 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