Outputing engineering cost based on total cost of project. Looking for help with matching

Please Login or Register  to view this content.

Originally Posted by shg

=lookup(b2, a6:b22)

Assuming b2 is the project overall cost, I want to look at the data and find similar pricing. Example is we have an overall cost of 14500, the output will be $2500 because we are in between 14000-15000.

Im having no luck with you suggestion. Thanks for helping me. Any other suggestions?

---------- Post added at 05:17 PM ---------- Previous post was at 05:16 PM ----------

Originally Posted by CRIMEDOG

Please Login or Register  to view this content.

I'm not able to make it work yet. I'll keep looking at it.

---------- Post added at 05:24 PM ---------- Previous post was at 05:17 PM ----------

I got it. Thanks guys. I was able to use either of them. I just had an error in one of my other formulas. thanks. Ill add kudos

@ cadamhill

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.