If contained in the list return value

**lilit2222** · 07-20-2021, 09:01 AM

Hi All,

I would like to write a formula such that a value of "High" is returned in Column B of sheet1 if the name of country in Column A is contained in the LIST OF COUNTRIES in another sheet (reference sheet).

See the test workbook attached.

**alansidman** · 07-20-2021, 09:12 AM

If you use this formula, it returns TRUE instead of High

=IFNA(VLOOKUP(A2,'Reference List'!$A$2:$A$25,1,0)=A2,"")

**lilit2222** · 07-20-2021, 09:43 AM

thanks, but I need to value of "High" to be returned. that's important.

**alansidman** · 07-20-2021, 09:59 AM

Here is a VBA solution for you.

Please Login or Register  to view this content.

How to install your new code

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button

If contained in the list return value

LinkBack

Thread Tools

Rate This Thread

Display

If contained in the list return value

Re: If contained in the list return value

Re: If contained in the list return value

Re: If contained in the list return value

Thread Information

Users Browsing this Thread

Similar Threads

Return a value if specific text is contained in range.

[SOLVED] Conditional format a list if some of its text is contained in another list

[SOLVED] Match 2 different text strings both contained in a cell, return value

Return a cell value if a date is contained in a range of cells

[SOLVED] How to Return Values Not Contained in a Range

Data Validation using a List allowing entries not contained in the List

Return a value if criteria contained in cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions