Hello,
Hope someone can help with this.
Please see the attached sample file. What I need is to lookup the matching 2 key IDs (i.e., ISIN and Firm_Quarters) in Sheet2 and then return the variable (i.e., market cap) in Sheet1. I have done one manually highlighted in yellow. Appreciate if someone can help me with a formula that does it automatically.
If possible, please reply to my email: [email protected]
Many thanks!!
try this
=INDEX(Sheet2!$B$2:$AS$26,MATCH(B2,Sheet2!$A$2:$A$25,0),MATCH(Sheet1!A2,Sheet2!$B$1:$AS$1,0))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
In C2
=INDEX(Sheet2!$B$2:$AS$25,MATCH(B2,Sheet2!$A$2:$A$25,0),MATCH(A2,Sheet2!$B$1:$AS$1,0))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Many thanks Ace!!
Many thanks to you too, Hemesh!!!
Last edited by mablelim; 01-06-2014 at 07:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks