# If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

1. ## If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

``Please Login or Register  to view this content.``
I feel like I'm on the right track with the above code, but I need "Results!C1" to equal any cell from a range instead of just cell "Picks!B94" (i.e. B94:G94). Any help would be greatly appreciated. I have attached the spreadsheet as well.

Book1.xlsx

2. ## Re: If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

Hi and welcome to the forum

perhaps if you can explain exactly what you are trying to do, we can offer some better suggstions for you to try?

looking at your sheet1, you have identical names in columns for each of your rows?

3. ## Re: If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

Try this...

Entered in C2:

=IF(COUNTIF(Picks!\$B94:\$G94,C\$1),VLOOKUP(C\$1,scores,2,0),"")

Copy across then down as needed.

4. ## Re: If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

Originally Posted by Tony Valko
Try this...

Entered in C2:

=IF(COUNTIF(Picks!\$B94:\$G94,C\$1),VLOOKUP(C\$1,scores,2,0),"")

Copy across then down as needed.
Works perfectly. I had no idea COUNTIF could do that. I've only used it for... well, counting. Thanks again!

5. ## Re: If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?

You're welcome. Thanks for the feedback!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1