Never mind delete this post... sorry to make the mod gods unhappy

**19FarmHand78** · 08-21-2012, 01:52 PM

I'm trying to make up a spreadsheet for figuring post frame building materials, I feel I'm doing good so far, have it all laid out how I want it, and have formulas in place to figure things the way I want. Also have sheets with prices.

First thing I want to know how to do is; say I'm using 2x4's 12' long... in C27 I have my set lumber size of 2x4, in D27 I input the length (in this case 12) in E27 I would input the amount needed X I would like for the program to input the price per each in F27... In G27 I have the formula =roundup((E27*F27),0) this gives me the total I want in column G. Is there a way I can have excel look up on another page, since I entered (12) in D27 it will automatically input my cost per each into F27... on my Lumber page I have all my lumber sizes that I will ever use listed out example is A$ would be size (2x4) B4 would be length (12) and C4 is price per ea($x.xx) this is where I would enter my prices on a monthly bases, for price increases.

Is there any way to do this? In a nut shell I have set lumber sizes for different aspects of the building, so I want to be able to input a length in one cell, and have the correct price in another.
I hope this makes sense cause I have confused myself.

Thanks

**dilipandey** · 08-21-2012, 02:43 PM

HI 19FarmHand78,

Welcome to the forum.

Suggest you to change the thread title to reflect the query being asked. thanks.

regards,
DILIPandey

<click on below 'star' if this helps>

**19FarmHand78** · 08-21-2012, 03:56 PM

I'm not even sure what I am asking, or how to word it?

**650dozer** · 08-21-2012, 09:16 PM

I think what you may be looking for is a vlookup formula. without looking at it I not sure though

**Cutter** · 08-21-2012, 09:46 PM

Hello 650dozer, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

---------- Post added at 09:46 PM ---------- Previous post was at 09:44 PM ----------

Hello 19FarmHand78, and welcome to the forum.

Please read the following rule about thread titles in order to help you change your title:

Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT (on first post) then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.