Dear All,
Currently I am facing a problem in excel.
I want to pull column G data after matching column A&B,C with that of column F and Column H. When it matches then it must pull or pick up data from G column correpsonding to the correct entry.
Hoping a desired solution as usually.
With Best Rgds
Hi there. Is this what you wanted (your expected results were all 0)...
If not, please shout!!
These are Array Formulas. They're a little different from ordinary formulas in that they MUST be 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 the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly braces yourself - it won't work...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanx for the reply.It did work.I would prefer to use vlookup with match function combinedly.Can u help in this regard.
Why? In what way does INDEX-MATCH fail to deliver on your expectations?
VLOOKUP works (unless you go complicated) works from left to right. Your data is not organised in that way.
=IFERROR(VLOOKUP(A3&"/"&MID(B3,4,255)&"/"&C3,CHOOSE({1,2},$F$3:$F$11&"/"&$H$3:$H$11,G$3:G$11),2,0),"")
try this array formula
@Glen your formula is working nice for example provided by OP but in real time it may give wrong result for example
in F5:H5 if the data is L/111210 Hari 144 instead of L/1112 Hari 10144
it will give wrong result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks