#1
|
|||
|
|||
INDEX and MATCH nesting with if
Hi Guys
I have attached my worksheet for your council. I will use the cell references from the actual worksheet to try and make what I need to do clear. CELL C26 =IFERROR(INDEX($F$11:$F$20;1,1);"") I want this cell to reference F11:F20 to find the result. IF it does not find a result I want it to reference O4:O8 If a result if found, how can I stop the next cell G26 from duplicating the results in C26? I had the worksheet setup using nested VLOOKUP's which worked well EXCEPT when it came to duplicating the results. I could not find a solution to stop the search if a result was found in the previous lookup. So in short: C26, G26, C30, G30,C34,G34,C38,G34,C42,G42 are the searching formulas. I would like the formula to stop referencing once it finds a result in the previous cell |
#2
|
|||
|
|||
Perhaps instead of showing us a formula for C26 you should tell us what the displayed value of that cell should be and why.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help using Index match for below | Maneesh Joshi | Excel | 2 | 11-29-2018 06:23 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
Index Match function | jackzha | Excel | 5 | 12-03-2014 12:43 PM |