-
Package: Technical Appli...
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- Analyst Essentials
- Analyst Essentials Pro
- Merger Modeling Basics
- Overview of Financial Markets
- Accounting for Finance
- DBS MODULE 1: FUNDAMENTAL/FOUNDATION
- WST Internal Instructors
- Advanced Excel for Data Analysis (2016 Singapore)
- Fundamentals of Financial Modeling (PKA)
- Fundamentals of Valuation Modeling (PKA)
- JPM-AM 2015 Excel Exam
- JPM-IM 2015 Valuation Exam
- Strategic Alternatives: M&A and Buyout Options
- Excel for Entrepreneurs
- Wall Street Certification Bundle
- Financial Modeling Starter Kit
- WST Professional Development
- Quizzes & Exams - WST Internal
- Keys to Success
- Oppenheimer Pre-Work Package
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Quiz/Exam for Package 1 - Finance 101
- Quizzes/Exams for Package 1
- Package 2: Core Fundamental Concepts
- Quizzes/Exams for Package 2
- USF - Corporate Valuation Methodologies
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
- AIB Add-on
Vlookup and Match
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Formatting issues when trying to use match/vlookup
hi-
I have 2 sets of data and want to see if the securities in the first list are also in the second and then pull certain characteristics (isin, coupon, etc) from one to the other.
I was advised to use match first and then vlookup. with the first step i have a formatting issue when using iss...
Read More
(1) Copy the value in the “Closing Price” column to a separate column
(2) Sort the copied Closing Price in a descending order (Highest to the lowest)
(3) Use “MATCH” function to locate the Closing Price
(4) Use “OFFSET” function to identify the corresponding Trading Date
Then I notice that for example, if on trading dates 9/15/2017, 10/05/2015, and 8/10/2017, they all had the same closing price of $50.00, then my result would display the Closing Price $50.00 three consecutive times and each shows the “Same Location” and the “Same Trading Date, 8/10/2017”.
Questions: Is my approach correct?
=> If ‘Yes’, how shall I fix the problem?
=> If “No”, I shall appreciate it very much the smart way to accomplish my original objective, i.e. “To display the Closing Stock Price in a descending order with corresponding Trading Date next to each Closing Price in a defined time period”
Thank you very much in advance for your wisdom and advice.
Peter C. Read More