Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2019, 03:01 AM
Peter Simpson Peter Simpson is offline INDEX and MATCH nesting with if Windows 10 INDEX and MATCH nesting with if Office 2007
Novice
INDEX and MATCH nesting with if
 
Join Date: May 2019
Posts: 1
Peter Simpson is on a distinguished road
Default 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
Attached Files
File Type: xls Montague Gardens Deliveries - Copy.xls (187.5 KB, 8 views)
Reply With Quote
  #2  
Old 05-27-2019, 06:53 AM
NoSparks NoSparks is offline INDEX and MATCH nesting with if Windows 7 64bit INDEX and MATCH nesting with if Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Perhaps instead of showing us a formula for C26 you should tell us what the displayed value of that cell should be and why.
Reply With Quote
Reply

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 and MATCH nesting with if Index Match function jackzha Excel 5 12-03-2014 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft