Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
match based on 2 conditions
i am trying to match a verb from a column on a worksheet to the same verb in
a column on a different sheet but only if the verb is being used (which is indicated by a "Yes" in the verb's adjacent column). Then, where the verbs match, I need the value of the fourth column on the same row where the "Yes" and matched verb are. So far I have is this formula: =IF(INDEX(Verbs!B:B,(MATCH(M4,Verbs!C:C,1)))="Yes" ,(VLOOKUP(M4,Verbs!C:G,4))," ") while it works in most cases, there are some cases where the verb exists more than one time. One verb may have a "Yes" and the other doesn't but the formula is not returning the correct value of the 4th column. Also, if I change my "Yes" from one verb to the other [same] verb, the formula does not recalculate and give me the new value of the 4th column. PLEEEEEEEASE help. What am I doing wrong.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
Formula to match two conditions | Excel Discussion (Misc queries) | |||
Match 2 Conditions then Avg Range | Excel Discussion (Misc queries) | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) |