Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use VLOOKUP with CHOOSE Function in Excel?

Date:2021-12-29 Author:Sandra

You definitely know the VLOOKUP Function or CHOOSE Function. VLOOKUP Function can help us to search for a certain value in a column. But in fact, there are often many cases that need to search according to multiple conditions, and there is no ready-made function at present.

So, we can use the composite functions, that’s VLOOKUP and CHOOSE Functions. Let’s get started.

How to Use VLOOKUP with CHOOSE Function in Excel?

There is a sheet containing different prices of different fruits in different supermarkets.

If we want to quickly get to know that the price of banana in supermarket F. so the supermarket F and banana are the conditions.

Enter this in cell C15

=VLOOKUP(C12&C13,CHOOSE({1,2},A2:A10&B2:B10,C2:C10),2,FALSE)

In this case, it’s the exact lookup, so enter FALSE.

When we’re done with the function, we usually press Enter key, and since this is an array formula, we need to press Ctrl, Shift and Enter keys together.

How to Use VLOOKUP with CHOOSE Function in Excel?

We made it.

How to Use VLOOKUP with CHOOSE Function in Excel?

How about three or more than three conditions? Actually, it’s similar like this.

How to Use VLOOKUP with CHOOSE Function in Excel?
How to Use VLOOKUP with CHOOSE Function in Excel?

Grasp the usage of the composite function of VLOOKUP and CHOOSE can save you much time.

Hope you can really understand this and put it in your control.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *