# 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 Second table ## 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.

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