🌐
Microsoft Support
support.microsoft.com › en-us › office › vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
VLOOKUP function - Microsoft Support
If you don't specify anything, the default value will always be TRUE or approximate match. ... =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
🌐
OpenWA
openwa.pressbooks.pub › msexcelbootcamp › chapter › chapter-16-functions-lookups-logical
Chapter 16: Functions – Lookups / Logical – MS Excel Bootcamp
April 1, 2023 - It can be considered a more elegant function, with only 3 arguments needed in most cases because the default match mode is 0 (exact match). However, it can be less intuitive to learn because it can have additional logical arguments ...
Discussions

In Excel, I wonder that how to use VLOOKUP function in OR logic - Stack Overflow
It is excluded that different Nation's Account in a row. I am sorry for my poor English, and please help me who has some good idea about it. I tried VLOOKUP function, but it can't read two columns for searching. More on stackoverflow.com
🌐 stackoverflow.com
VLOOKUP with multiple conditions or something like that?
u/Exciting_Grab_8441 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
🌐 r/excel
38
87
May 24, 2022
How can I use vlookup with if and statements?
u/sk8er_girl90 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
🌐 r/excel
5
19
November 7, 2021
How to use vlookup to pull formula instead of value?
u/Smellysocks23 - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
🌐 r/excel
27
17
March 29, 2022
People also ask

What are the limitations of using a VLOOKUP?
The main limitations of the VLOOKUP function are: 1. VLOOKUP can only look up values to the right on the lookup_value. i.e. the lookup only works left to right. You’ll need XLOOKUP, or INDEX MATCH for a right to left lookup. 2. VLOOKUP can only perform a vertical lookup across columns. It cannot search across rows. For a horizontal lookup, you’ll need HLOOKUP or XLOOKUP. 3. A VLOOKUP function does not automatically update when a formula is added. 4. By default, the VLOOKUP function does not find an exact match. It returns a #N/A. To return an approximate match using VLOOKUP, you must set the
🌐
academyoflearning.com
academyoflearning.com › blog › vlookup-example-how-to-do-a-vlookup-in-excel
VLOOKUP Example | How to do a VLOOKUP in Excel | Academy of Learning ...
What is the difference between VLOOKUP and IF?
VLOOKUP retrieves data from a table based on a key, while IF evaluates a condition and returns different outputs depending on whether the condition is true or false.
🌐
owox.com
owox.com › blog › articles › how-to-use-vlookup-with-if-statement-in-google-sheets
Using VLOOKUP with IF Function in Google Sheets
What is the syntax for using 'IF' with 'VLOOKUP' in Google Sheets?
You can place the VLOOKUP inside the IF statement's logical test or value parameters to control the output based on conditions.
🌐
owox.com
owox.com › blog › articles › how-to-use-vlookup-with-if-statement-in-google-sheets
Using VLOOKUP with IF Function in Google Sheets
🌐
DataCamp
datacamp.com › tutorial › if-vlookup
How to Use VLOOKUP() with IF() in Excel | DataCamp
July 18, 2024 - Is_sorted is a logical value (TRUE or FALSE). You can use TRUE (or 1) for numbers and FALSE (or 0) for text. If TRUE, VLOOKUP() assumes that the first column of the range is sorted in ascending order and returns the closest match. If FALSE, VLOOKUP() searches for an exact match.
🌐
Vlookup
vlookup.com › excel › vlookup-if
VLOOKUP with IF statement in Excel
... The number of the column that contains the Result, within the Search range. ... Indicates if you want VLOOKUP to look for an approximate or exact match. ... A logical test or value that can be evaluated as TRUE or FALSE.
🌐
USD
td.usd.edu › TDClient › 33 › Portal › KB › ArticleDet
Article - VLOOKUP Function in Excel
range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.
🌐
Microsoft Support
support.microsoft.com › en-us › office › lookup-function-446d94af-663b-451d-8251-369d5e3864cb
LOOKUP function - Microsoft Support
array Required. A range of cells that contains text, numbers, or logical values that you want to compare with lookup_value. The array form of LOOKUP is very similar to the HLOOKUP and VLOOKUP functions.
🌐
Medium
medium.com › @basubinayak05 › logical-and-lookup-functions-in-excel-48bce24e8451
Logical and Lookup functions in Excel! | by Binayak Basu | Medium
April 14, 2023 - The general syntax for the VLOOKUP function is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) ... “range_lookup” is a logical value that specifies whether the VLOOKUP function should find an exact match or an approximate ...
Find elsewhere
🌐
Academy of Learning
academyoflearning.com › blog › vlookup-example-how-to-do-a-vlookup-in-excel
VLOOKUP Example | How to do a VLOOKUP in Excel | Academy of Learning Career College
June 20, 2022 - You can combine the VLOOKUP function ...nd”,”Not Found”) Here we have nested our VLOOKUP inside an IF function. The IF function performs a logical ......
🌐
Owox
owox.com › blog › articles › how-to-use-vlookup-with-if-statement-in-google-sheets
Using VLOOKUP with IF Function in Google Sheets
October 10, 2025 - VLOOKUP searches for a specified value in a table and returns a corresponding value from another column, while IF statements perform logical tests to return specific values based on conditions.
Top answer
1 of 1
1

If I have understood correctly, then you could use the following formula, assumptions per tags there is no Excel Constraints therefore the given formulas should work :


=UNIQUE(VLOOKUP(TOCOL(D3:E3,1),O$3:P$15,2,0))

Or, If not using Structured References aka Tables then using BYROW() spill it for the whole data :

=BYROW(D3:E15,LAMBDA(α, UNIQUE(VLOOKUP(TOCOL(α,1),O3:P15,2,0))))

NOTE: The above formulas will return Unique Values, since some of the rows have double INPUT data, so if you want them to concatenate then in place of UNIQUE( replace it with TEXTJOIN(", ",1, however, which i assume is not needed. MS365 Exclusive!!


Explanations:

  • Firstly, using TOCOL() function, we could have also used TOROW() but completely missed it, anyways. Using TOCOL() it converts the 1x1 data into a single column array as well as excludes if any empty cells.
  • Secondly, using VLOOKUP() function to grab the Nation column from the other range based on the Lookup_Value we have to get an Exact Match.
  • Finally, using UNIQUE() function to exclude the duplicates as both Accounts has same Nation. Here I have assumed one would need the duplicates as well as one is not asking to join the return outputs. Also, if you intent to use TOROW() then ensure to select the second parameter of UNIQUE() function which is [by_col] thus the formula will be:

=UNIQUE(VLOOKUP(TOROW(D3:E3,1),O$3:P$15,2,0),1)

  • Last but not least, if you want to spill instead of drag down for the rest of the cells, then could use LAMBDA() helper function BYROW() which does the same operation as above but ensure to do it for each row to return one single output as an array, however from the screenshot in your OP, it won't work as it seems you are using Structured References aka Tables as for now it doesn't support #SPILL features. Hope it explains well.

🌐
Excel Off The Grid
exceloffthegrid.com › vlookup-what-does-the-true-false-statement-do
VLOOKUP: What does True/False do? (How to avoid errors!)
January 21, 2026 - In the function library, the range_lookup is described as: “A logical value; to find the closest match in the first column (sorted in ascending order) = TRUE or omitted; find an exact match = FALSE.”
🌐
Ablebits
ablebits.com › ablebits blog › excel › vlookup › if vlookup in excel: vlookup formula with if condition
IF VLOOKUP in Excel: Vlookup formula with If condition
March 17, 2023 - The above values go to the logical test of the IF function, which does one of the following: If the logical test is TRUE (#N/A error), your message is displayed. If the logical test is FALSE (lookup value is found), Vlookup returns a match normally.
🌐
TechOnTheNet
techonthenet.com › excel › formulas › vlookup.php
MS Excel: How to use the VLOOKUP Function (WS)
The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.
🌐
Got It AI
got-it.ai › solutions › excel-chat › excel-tutorial › vlookup › if-function-and-vlookup
How to Use VLOOKUP and IF Functions Together| Excelchat
February 13, 2023 - It performs a row-wise lookup until a match is found. The IF function performs a logical test and returns one value for a TRUE result, and another for a FALSE result. IF and VLOOKUP functions are used together in multiple cases: to ...
🌐
W3Schools
w3schools.com › excel › excel_vlookup.php
Excel VLOOKUP Function
AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR · Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates · Excel Exercises Excel Syllabus Excel Study Plan Excel Certificate Excel Training ... The VLOOKUP function is a premade function in Excel, which allows searches across columns.
🌐
Exceljet
exceljet.net › vlookup with multiple criteria
VLOOKUP with multiple criteria - Excel formula | Exceljet
May 10, 2024 - Working from the inside out, the IF function in this formula, which is entered as the "table_array" argument in VLOOKUP, runs a logical test on the value in column C "Years", which represents the number of years a salesperson has been with a company.
🌐
ListenData
listendata.com › home › excel functions
VLOOKUP Function: A Step-by-Step Tutorial
col_index_num - It is the column ... - Find an exact match. Note : If you don't enter a value in the fourth parameter "range_lookup" of vlookup, excel will consider 1 as a logical value i.e....
🌐
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › vlookup
VLOOKUP
July 11, 2024 - #N/A! error – Occurs if the VLOOKUP function fails to find a match to the supplied lookup_value. ... The formula attempted to reference cells that do not exist. ... The range_lookup argument is not recognized as one of the logical values TRUE or FALSE.
🌐
Wall Street Mojo
wallstreetmojo.com › home › all blogs › excel resources › vlookup function in excel
VLOOKUP Excel Function - Examples, Tutorial, How to Use?
September 1, 2025 - The VLOOKUP Excel function works for numerical, textual, and logical values. For example, an organization uses VLOOKUP to retrieve the monthly revenue of multiple products based on the product code (unique identifier).
🌐
Fullcirclecomputing
fullcirclecomputing.com › microsoft-office › using-an-if-statement-combined-with-a-vlookup-function
Using an Excel IF Statement Combined with a VLOOKUP Function - Full Circle Computing
June 26, 2020 - If the Profit Earned is not greater than $1,000, the Commission Earned is 0. Select the cell in which you want the results of the IF/VLOOKUP function to appear. Cell I2 in picture above. You would need to create an “IF” function first… ... First argument — you’ll build the logical test to only get the records where the Profit Earned > $1,000.