How to print value by matching data on two columns..

[mohit999]

I have data in column C than I need to print correctly in column G by matching the contents of column E with column A and than matching column F with column B. I know how to do Vlookup on a single column but I couldn't figure out this one. I need the value in column G as shown clearly in image and also attached excel.

Sample.png

[JeteMc]

Try pasting the following formula in G2 and then double click the fill handle to copy down:

Please Login or Register  to view this content.

Let me know if you have any questions.

[JeteMc]

On the off chance that the reason to do this is to get a list sorted (descending) by value. Look at columns I:K where K was created by copying column C and then sorting largest to smallest. The entries in columns I and J are then populated respectively with the formulas:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Here is a copy of your file: Sorted List.xlsx

[mohit999]

thank you jetemc for the formula. Actually I add data to the excel everyday so if row number increases from 23 to 455 or any other number then I have to change A$23 to A$455, B$23 to B$455 and C$23 to C$455 every time ?

[udprocks]

thank you jetemc for the formula. Actually I add data to the excel everyday so if row number increases from 23 to 455 or any other number then I have to change A$23 to A$455, B$23 to B$455 and C$23 to C$455 every time ?

no need to update again and again just change once and it will be same.

[JeteMc]

Actually I add data to the excel everyday so if row number increases from 23 to 455 or any other number then I have to change A$23 to A$455, B$23 to B$455 and C$23 to C$455 every time ?

I found an problem with the formulas. The formula that was retrieving the names was getting duplicates such as Down Time for both of the values of 49.5. We need to change both the name retrieval* and date retrieval formulas, respectively, as follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

*Note: the name retrieval formula is an array formula meaning that after it is pasted you'll need to press the F2 key and then press the Ctrl, Shift and Enter keys simultaneously to activate it. Also note that both formulas now access whole columns at a time which means that you don't have to change the range when new data is added. This is not my preferred way to write a formula as it slows down calculation and makes it nearly impossible to evaluate the formula if there is an error, however in the circumstance you mention in post #4 it is perhaps the best option.
Here is a copy of the file with the new formulas applied in columns I and J: Sorted List.xlsx
Let me know if you have any questions.

[mohit999]

Thank you JeteMc.

[JeteMc]

You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.