• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pick up content in a cell based on criteria in another?

rajkenya1

Member
Pick up content in a cell based on criteria in another?


Hi Guys I am looking for a formula in say C26 that will pick up the content in C4 if the criteria in cell D4 is V and so forth.


Find attached spreadsheet where I have manually shown this. Can someone help me formularise it.
 

Attachments

  • Criteria.xlsx
    11.4 KB · Views: 4
Thanks fpr replying Nebu

But what if i want to drag the formula down and also across to pick the contents of the others cells? The formula above doesn't work?
 
If you want a separate table with simply the Rows where Column D is a V, couldn't you simply filter the data in place ?
Select C3:I23
Goto the Data, Insert, Insert Table tab
Click that your table has headers
Now click on the Drop down in Column D and only select V
 
Hi Hui

Thanks for your reply. I want to pick up this data in another sheet as there is further analysis to be done as the V and F will keep changing. What i sent was a sample in just one sheet and after a solution is found i will tailor the formula and apply it to my workings based on it picking from the other sheet.
 
Was looking for the super like button.

WOW! thats amazing. Works well. I will now try it on my actual worksheet.

Thank you thank you thank you
 
Back
Top