How to sort 2 datasheets that have linked formulas

		Microsoft Office Forums > Microsoft Excel > Excel
How to sort 2 datasheets that have linked formulas

FAQ

Thread Tools

Display Modes

#10

06-08-2017, 04:43 AM

NBVC

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

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Doing a linked paste within a linked spreadsheet	tkondaks	Word	1	08-17-2012 12:23 AM
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.