Guess that would all depend on what you are trying to do? are you trying to read from a spreadsheet into a CF page? Do you have these numbers in a query output and just need to reproduce the formula in your CF page?
Could use a little more detail ;o) -----Original Message----- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 1:17 PM To: CF-Talk Subject: Excel 'Lookup' Function I'm really stumped here. Can anybody tell me how to turn this Excel formula into CF friendly code? =LOOKUP(B58,$A47:$A52,B47:B52)+(B57/100)*(B167-LOOKUP(B57,$A39:$A45,B39: B45)) I'd be forever in your debt!! :) Thanks! -- Jillian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
