How do you do a Vlookup when the same value is repeated?

As mentioned in the beginning of this tutorial, there is no way to make Excel VLOOKUP return multiple values. The task can be accomplished by using the following functions in an **array formula**: IF - evaluates the condition and returns one value if the condition is met, and another value if the condition is not met.

How do I copy a VLOOKUP formula to another column?

Does VLOOKUP only work left to right?

The VLOOKUP **function only looks to the right**. To look up a value in any column and return the corresponding value to the left, simply use INDEX and MATCH. 1.

## Related Question How do I use VLOOKUP in Excel?

### Can I use Vlookup inside an if statement?

Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the VLOOKUP in the “value if true” part of the IF statement.