PDA

View Full Version : Vlookup Choose for 3 table after criteria macth



amartakale
09-27-2019, 12:45 AM
I want Vlookup Choose for 3 table after criteria macth excel formual

Bob Phillips
09-27-2019, 05:48 AM
If there can only be one value for AAA, why does your results table have 3 rows?

amartakale
09-27-2019, 06:59 AM
Sorry Sir

Actually I copy above format & paste it below.But ignore it. Pls refer this sheet.25166

Bob Phillips
09-27-2019, 07:34 AM
I fail to see how the second set of results will differ from the first. The first already gives a breakdown, albeit it refrs to 1,2,3 not AAA, BBB, CCC.

david000
09-27-2019, 04:42 PM
You could use: =VLOOKUP(E$13,INDIRECT("'"&"All Universe Stocks Schemewise"&"'!"&$C14),2,FALSE) on your second example.

amartakale
09-29-2019, 11:53 PM
First Sorry for late reply….

Dear xld (http://www.vbaexpress.com/forum/member.php?2139-xld) & david000 (http://www.vbaexpress.com/forum/member.php?9495-david000) Sir ,

Thanks for solution its works. Actually I got answer already in first attempt as per xld sir & its right but I was confused. Now I understood my mistake. Both formula gave me same answer.

Thanks one again both.

Regards
Amar
25178