Skip to main content

Match a Single Value in Multiple columns (Excel Tricks)

Hii All,

After a long long time I am back. I always want to share some new things which may be useful for some or the others like me but due to busy schedule in my job I do not get time for the same.

Anyways, today My friend asked a query that he want to match a Single Value in Multiple Columns of the source data and if it matches anywhere in the those columns it will bring the related cell value 

The below pic will clear more about his query.


So it is bit tricky as normally you can use Excel Match formula in a single column, But with the Excel IfError Formula you can solve the issue.


The formula is 

=INDEX(M5:M9,IFERROR(MATCH(D5,J5:J9,0),IFERROR(MATCH(D5,K5:K9,0),MATCH(D5,L5:L9,0))))


You can also download the example file by clicking below link.

Matching Single Value in Multiple Columns


Hope this post is useful and you can corelate a situation where you needed something like this.


Thanks...
 

Labels:

Comments

Post a Comment

Popular posts from this blog

Password Protect your USB Flash Drive without any software....

I was trying to protect my USB flash drive from a long time but didn’t find anything nice. Almost all the software were either not giving full features or were asking for money to do so and give full benefits. One software called Truecrypt was nice but not giving me simple password protection feature. Anyways, now I submit one good info with all who want to simply password protect their USB flash drive / pen drive without all unnecessary softwares. Steps to protect your USB flash drive 1.       Insert your pendrive. 2.       Open the drive 3.       Create a folder (lets name is ABCD) and keep all your data in it. (You can partially protect this disk too by moving your important / secure data only into this folder) 4.       Remember a password. Lets name is 12345 5.       Now open a note pad and copy and paste the following text into it: -...
10 comments
Read more

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing
2 comments
Read more

Difference Between Consignment And Sales

Consignment can not be treated as sales of goods. It is different from sales. The difference between consignment and sales are as follows: 1. Ownership Consignment: The ownership of the goods remains with the consignor until sales is effected by the consignee. Sales: The ownership of the goods immediately transferred to the buyer when sale is effected. 2. Relationship Consignment: The relationship between the consignor and consignee are of principal and agent. Their relation ship are continued till terminated. Sales: The relationship between the two parties are that of seller and buyer and they terminated as soon as payment is made and goods are delivered. 3. Expenses Consignment: The expenses incurred by the consignee to execute sale and the expenses incurred by consignor to send the goods to the consignee, both are borne by the consignor. Sales: Any expenses incurred after the sale is not borne by the seller. 4. Risk Consignment: The risk of goods under c...
8 comments
Read more