Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 06-08-2017, 04:43 AM
NBVC's Avatar
NBVC NBVC is offline How to sort 2 datasheets that have linked formulas Windows 7 64bit How to sort 2 datasheets that have linked formulas Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

Sorry the MATCH() reference was incorrect. It should be referencing Cost Summary!B:B

=IFERROR(LOOKUP(INDEX('Cost Summary'!H:H,MATCH(A2,'Cost Summary'!B:B,0)),{0,6,7},{0,-2,-3}),"Select Bridge Length")

=IFERROR(LOOKUP(INDEX('Cost Summary'!J:J,MATCH(A2,'Cost Summary'!B:B,0)),{"Minor","Moderate","Nominal","Su bstantial"},{-1,-2,0,-3}),"Select Earthworks Allowance")

Please try again
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort 2 datasheets that have linked formulas help with formulas ferrarifx Excel 2 11-16-2016 12:04 PM
Using Right and Len formulas together PDGood Excel 4 11-20-2015 06:50 AM
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
How to sort 2 datasheets that have linked formulas Doing a linked paste within a linked spreadsheet tkondaks Word 1 08-17-2012 12:23 AM
How to sort 2 datasheets that have linked formulas IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 PM.


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