![]() |
#10
|
||||
|
||||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
tkondaks | Word | 1 | 08-17-2012 12:23 AM |
![]() |
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |