Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF(MATCH(A3:B3,Mix1!E7:F16),Mix1!T7,0), doesn't work, what will?
I posted this before and when I came back to look for it, I could't find it.
So I'm sorry if it's up here twice. I thought that the first fix I got worked but then realized it didn't. What I need is for the MATCH statement (or any statement) to be TRUE only when the the values in A3 & B3 match exactly with two cells in a row of the array Mix1!E7:F16. Is there a way to do this? Thankyou. -- Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Service work order | Charts and Charting in Excel | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
how is possible working on work sheet by two person in the netwo. | Excel Worksheet Functions | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
How do I ensure dates inputted are during the work week? | Excel Worksheet Functions |