» Retrieving Matching Values From Not Adjacent List
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Columns A & B contain numbers and matching letters.
However, rather than being adjacent, each letter in column B is shifted down one row with respect to its matching number in column A.
We want to retrieve the matching letter for each number.
Solution:
Use the INDEX and MATCH functions as shown in the following formula:
=INDEX($B$2:$B$7,MATCH(C2,$A$2:$A$7,0)+1)
Book Store:
Recommended Books:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Windows XP Pocket Reference
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Interpretation of Financial Statements
- Microsoft Windows XP Step by Step (With CD-ROM)
Re: Retrieving Matching Values from Not
VBA Noob
Alexis121,Welcome to the forum
Thread closed. Please start you're own thread
[I]Your post does not comply with Rule [B]2[/B] of our Forum [/I][URL="http://www.excelforum.com/forum-rules/642590-forum-rules.html"][COLOR=#800080]RULES[/COLOR][/URL]. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
VBA Noob
I know the IF function will search the row adjacent to the code in column A but I need to see if the postcode appears in any of the cells in column B.
Thank you if you can help!!