Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to LookUp with Index/Match by range name

0

How to replace the cell names with range names?

Answer
Discuss

Discussion

Your question has insufficient detail. Make sure that your question is fully explained in your post. Do not use the attached workbook to explain your question. The attachment should be intended to test and return an answer that you can use immediately. Therefore it's very useful but it shouldn't be the key.
As things are, you made no attempt to make your question clear in your post, and your workbook doesn't provide any further detail, either. However, I suggest that you google for "INDEX/MATCH". You will find dozens of tutorials. Six of them are listed on your screen at this moment. Look at the list on the left of this post. Also learn about naming ranges in particular and the Names Manager in particular.
Variatus (rep: 4889) Aug 18, '20 at 3:59 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login