Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
———
Start your career in Graphic Design with the WonderHowTo's Beginners’s Guide to Photoshop Course
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Clear data & cell contents in Excel using a macro
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Create a Tangent Line with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Graph the probability density function in an Excel file
How To:
Conditionally format at every change in value in Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a pass-fail grade formula in Microsoft Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Update inventory records by formula in Microsoft Excel
How To:
Create an Excel inventory template with running totals
How To:
Compare two lists and extract the new values in Excel
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Clear data & cell contents in Excel using a macro
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Create a Tangent Line with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Graph the probability density function in an Excel file
How To:
Conditionally format at every change in value in Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a pass-fail grade formula in Microsoft Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Update inventory records by formula in Microsoft Excel
How To:
Create an Excel inventory template with running totals
How To:
Compare two lists and extract the new values in Excel
2 Comments
Thank you very much,but I want know How Data Validation and Conditional Formatting was done in this example.
Thank you very much, My questions was solved:
1 - B1 >Data Validation>List>Sweeter;Jacket;Pants
B2 >Data Validation>List>Small;Med;Large
2 - Conditional Formatting
Range A7:D14 > Formula =IF(AND($B7=$B$1;$C7=$B$2);TRUE)
3 - Last Price
B3 >Formula =LOOKUP(10^10;1/((B7:B14=B1)*(C7:C14=B2));D7:D14)
Is correct ? or nor ?
Thanks to you.
Share Your Thoughts