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)
Use this:
2 Matches: one for the line, one for the columnPlease 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)
Bookmarks