Hello again,
I have another question about vlookup a value where I have more than one criteria. Both criteria appear in the row alignment and not in column, so I cannot use the "Index/match" formula.
The subject name is the same in a couple of rows but the value to return is different.
Normally - the vlookup returns the value in first row it finds, and ignores the rest of the lines.
I attached a file for example, and would be glad in your assistance.
Thank you.
Last edited by Limor_OP; 01-20-2019 at 10:09 AM.
No file attached
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Thanks
I attached the file.
Basically the formula needs to look company name& symbol and return the price from column E.
Try...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.
Thanks but I m trying to pree the CTRL+SHIFT+ENTER, and I dont get the curly braces......The result is #VALUE!
any idea why?
Thanks! it works!!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks