Using vlookup to look for values in multiple columns

All we need is an easy explanation of the problem, so here it is.

I have the following table. I have another table with 52 rows for each week and I intend to add each name that the week is assigned to in the shown table.

The assigned weeks are divided into two halves of the year. Is there a way to use vlookup to look for a week number in the two columns and then return the name?

First table

Using vlookup to look for values in multiple columns

Second table

Using vlookup to look for values in multiple columns

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Assuming the tables are arranged as in the first image below, try the formula:

=IFERROR(VLOOKUP(F2,$A$2:$C$8,3,FALSE),VLOOKUP(F2,$B$2:$C$8,2,FALSE))

VLOOKUP is used for both columns in combination with IFERROR. Checking the first column for the lookup value. If found it is returned. If not found, meaning there is an error, the second VLOOKUP checks the second column and returns the lookup value.

Drag it down to fill the other cells. Make the appropriate change so the ranges match yours.

Formula
Using vlookup to look for values in multiple columns

Result
Using vlookup to look for values in multiple columns

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply