multiple answers

Hi Please can someone help, I have a formula that looks at a cell and returns a 1 if it matches the criteria and doesn't contain another specific word. Here is the formula: =AND(COUNT(SEARCH({"Apple","Orange","Peach"},$A2))>0,COUNT(SEARCH({"Pears"},$A2))=0) The problem I have is I want it to...

I got a task in which i have 2 Files One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail And there is Another file containing Daily Collection with payment 2 Detail In Master File there are two column Pay 1 Pay 2(Values Coming From Another File...

Hey everyone, I have a sheet with 500 values that I need to vlookup against 50k products. Normally that woudnt be a problem with vlookup but in this dataset one value can have multiple results and vlookup only takes the first one. So my question is is there an easy way to get multiple vlookup...

Dear all. I have a data sheet which contains three data columns: Part code, Description and Bin# I need to make two searches within the "DESCRIPTION" column data (Shown by arrows in the image below) and find the PART No. and Bin# as the result. The problem is, both searches shall be done...

Hi wondering if anyone could help? I have a report on questionnaires I'm doing where I have to return the MAX and MIN values of the results. I first started using the =VLOOKUP(MAX(C4:C12),C4:D12,2,0) formula but it only returns the first MAX value to me but instead I want a formula that can...

Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...

I need help with a vlookup formula. Here's how it breaks down. If I have, in one cell (call it D1): EH,DR,HU,YU,SE,QT and in a lookup table on another sheet: A B C 1 ED T 2 EH F 3 DR G 4 HU H 5 SE E 6 YU U 7 QT R I need to be able to lookup the values in D1 on the table and...

I've read around and do not know if a nested IF statement Would be best, or a Case Select, or there may be something else I am unaware of that would perform better in my scenario. The responses in column T should be one of the following(answers are in bold) and should be answered for all data...

Hi! I have been trying to create a formula that will generate 1 of 3 possible answers with no luck. Here is what I need to happen: In column F if the total equals 3 or 4 then in column G the answer generated needs to be a 2. In column F if the total equals 5 or 6 then in column G the answer...