Index list from two columns based on number
I need help, please....
How to index two columns based on given number... like the picture shown below:
INDEXXXX.jpg
column A, B, C is the data, column E is the result i want it to be.
https://www.excelforum.com/attachmen...1&d=1526570415
Thank You for any help...
Enter array formula in E2 and copy down
***Array formula
...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.
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 05-17-2018 at 12:05 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thank you.... It works great..... It really helps my problem... Goodluck...Originally Posted by alkey
enter array formula in e2 and copy down
***array formula
...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.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks