LinkBack URL
About LinkBacks
Is it possible to use index match in place of hlookup? I can;t figure it out. I know how to for vlookup.
Is it possible to use index match in place of hlookup? I can;t figure it out. I know how to for vlookup.
It is the same way... you just have to use INDEX(Range,Line,MATCH
The Match will be something like:
MATCH("HeaderName",HeadersRange,0)
can you show me in this sample please?Originally Posted by Gatti
Use this:
2 Matches: one for the line, one for the column
Please Login or Register to view this content.
Try this...
=INDEX($B$2:$J$4,MATCH($L9,$A$2:$A$4,0),MATCH(M$8,$B$1:$J$1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you guys!
Happy to help and thanks for the feedback
Just an FYI, if you don't need to copy that formula, then Gatti's suggestion is fine. If you will be copying it down and/or across, you will need to lock the cell ref's with $, like I did
/\ Exactly! Glad to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks