LinkBack URL
About LinkBacks
Can you match multiple columns ?
=INDEX(Sheet1!$A$2:$A$20000,MATCH(A172&"Test",Sheet1!$J$2:$J$20000&Sheet1!$K$2:$K$20000,0))
Can you match multiple columns ?
=INDEX(Sheet1!$A$2:$A$20000,MATCH(A172&"Test",Sheet1!$J$2:$J$20000&Sheet1!$K$2:$K$20000,0))
Hi Ashtangi
It will be easier for everyone to understand your problem if you will attach excel file
Regards,
Hi and welcome to the forum
Yes you can, but you need to enter that as an ARRAY formula...
=INDEX(Sheet1!$A$2:$A$20000,MATCH(A172&"Test",Sheet1!$J$2:$J$20000&Sheet1!$K$2:$K$20000,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
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 FDibbins,
what about if A172 was actually a construced string
"*"&LEFT(A172,3)&"*"&RIGHT(A172,3)&"*"
i cant really have
"*"&LEFT(A172,3)&"*"&RIGHT(A172,3)&"*"&"Test"
what is in A172?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks