Thread: How to sort 2 datasheets that have linked formulas
View Single Post
 
Old 06-08-2017, 04:43 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit 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