How to extract and populate data based on two matching cells

I am trying extract data based on matching 2 cells. Can anyone help me with the formula?

For Example: If data in C1 = B3 then

  • How to customise skipping of rows while parsing an Excel file in node.js?
  • Powershell work with multiline text in Excel cell
  • Stop VBA Evaluate from calling target function twice
  • Get User Selected Range
  • online sql client
  • Filter and Fill visible cells with formula VBA
  • Populate

    b4     c4
    b5     c5
    b6     c6

  • Creating Mutiple Pivot Tables from single data source
  • Can't open excel file generated with excelLibrary
  • How to trim leading spaces while importing Excel into mysql
  • Re-Initializing “ThisWorkbook.Path”
  • Copy Column and Paste in the same worksheet a variable number of times
  • How to properly clean up interop objects in C#
  • One Solution collect form web for “How to extract and populate data based on two matching cells”


    Without knowing what values you want in the populated cells I’m not sure how to answer… however the basic formula is above…
    and example image below:

    enter image description here

    MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.