Hi,
I need a formula to get the value of Col C ("Number") in Sheet2 in the Col C of Sheet1 by matching Col A & B in Sheet2. Please find the sample data and kindly provide the formula, Much Appreciated if I got immediate reply.
Thanks,
Karthik
Hi,
I need a formula to get the value of Col C ("Number") in Sheet2 in the Col C of Sheet1 by matching Col A & B in Sheet2. Please find the sample data and kindly provide the formula, Much Appreciated if I got immediate reply.
Thanks,
Karthik
Best and easy solution is Helper column... see attached sheet.... Use of "&" is to concatenate two columns... Apple&Madurai=AppleMadurai
If done mark this thread as solved(see top "Thread Tools").. "Add Reputation" to answer if anyone helps you in this forum..
Last edited by mangesh.mehendale; 11-03-2015 at 09:00 AM.
Don`t care, take care...
Regards,
Mangesh
Enter this ARRAY formula in Sheet1!c2 and fill down:
Formula:Please Login or Register to view this content.
...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.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
An ordinary formula, as an alternative. Just set with "enter".
=IFERROR(INDEX(Sheet2!$C$2:$C$7,MATCH(1,INDEX((Sheet2!$A$2:$A$7=Sheet1!$A2)*(Sheet2!$B$2:$B$7=Sheet1!$B2),0),0)),"")
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
How abut this?
Formula:Please Login or Register to view this content.
Data Range
A B C 1 Item Type Number 2 Apple Madurai 25 3 Apple Chennai 35 4 Banana Madurai 45 5 Banana Chennai 55 6 Onion Coimbatore 65 7 Onion Trichy 75
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
Formula:Please Login or Register to view this content.
One more with UDF... Two criteria Vlookup..(Credit: http://www.mrexcel.com/forum/excel-q...riteria-2.html)
Note: While using UDF select atleast one extra row i.e. see in Sheet2 Data is from B2 to D7 but in UDF selected B2:D12
Please Login or Register to view this content.
Last edited by mangesh.mehendale; 11-05-2015 at 12:28 AM.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Last edited by Czeslaw; 11-04-2015 at 02:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks