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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.