multiple functions

Hello everyone, I wanted to know if there was a formula or macro that I could use which would look up a string of text in column B:B and if found in column D:D return the value which correlates to its row, but the value i want is in column A. Its hard to explain but i am attaching an image...

I'm pretty new to excel vba macro coding! So, not sure, if I'm putting my problem clearly enough! I'm working on a data of thousands of rows and around a dozen columns. Please note there's no unique value column, i.e. even though each column contains a unique set of values, irrespective of the...

I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same worksheet). Currently, I have the...

I have 2 columns and I need the formula to read column "A" first and if it meets a certain criteria to look at column "B" and count if there's any text in the cells. See the example to show what I'm looking for. I would want the formula to look at column a for pet type (e.g. dog) and then look...

I am trying how to figure out if I can use a MIN function from within a SUMIFS formula. I need the formula in the second criteria to look through a list of months, and see if it is the lowest month listed (compared to C4) for that team (compared to C3) and return the value. Basically like the...