Vlookup with drop down functionality

[Excel Dumbo]

Hello Dear Excel Gurus in here,

Please help me with the Vlookup formula together with a drop down functionality that will automatically update figures.

Thanks
Excel Dumbo

[Kyle123]

Maybe like this, you can change the yellow box

[sunil.excel]

Hi,
check this.....

[dilipandey]

Hi there,

You can use below array formula to achieve the desired results:-

Please Login or Register  to view this content.

See attached:-

regards,
DILIPandey

<click on below 'star' if this helps>

[Excel Dumbo]

Thanks a lot Dilip, Sunil and Kylie. The data I had submitted earlier was a miniature version of the huge file I was working on. I am still not there yet.

I have attached another version. If you could have a look and kindly advise. Thanks in advnace for your valuable time and effort

[dilipandey]

Hi there,

Did you had a look into my excel workbook posted in post#5 ?
If you arrange your data there and correct the references, that will work easily.
Also, suggest you to follow the data validation as I shown in my workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Kyle123]

Dilipandey, why use an array formula when a regular one would do?

[Kyle123]

I've updated your workbook, note that in it I have used an offset function to make things easier to understand. Use the evaluate formula tool if you have trouble following the formulas, but a better version of the formula in C3 would be:

Please Login or Register  to view this content.

But that might take a bit of getting your head round since you're a beginner.

[dilipandey]

@Kyle123 ->

I have used array support for matching two items using Match function like :- MATCH($A3&B$2,Actual!$A$1:$A$12&Actual!$B$1:$B$12,0)

If I don't use array for them, it would not work.

I liked your way of providing solution as well. Thanks for the heads - up though. Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[Excel Dumbo]

Thanks a lot Kyle, Sunil, Dileep. This is what I wanted.

[dilipandey]

You are welcome .. !!

Cheers

regards,
DILIPandey

<click on below 'star' if this helps>