Results 1 to 3 of 3

Thread: Excel Noob

  1. #1
    Squeeler Vini's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield
    Posts
    1,769
    Thanks
    44
    Thanked
    8 times in 8 posts

    Excel Noob

    In sheet (Requirements) I have a column “Ducting Dia”. What I want to do is when I enter the ducting dia in these columns I want the ducting weight to appear in column C “ducting weight per m”. The values for the weights is in sheet “Duct Weights” column B.



    In short when I enter a ducting size in one sheet I want it to put the weight into a column, these weights are calculated in another sheet.

  2. #2
    listen to escape fails :) luap.h's Avatar
    Join Date
    Jan 2004
    Posts
    569
    Thanks
    4
    Thanked
    2 times in 2 posts
    a vlookup will probably do the job, but I can't really say for sure from your description. Feel free to mail the sheet and I'll take a look

  3. #3
    Squeeler Vini's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield
    Posts
    1,769
    Thanks
    44
    Thanked
    8 times in 8 posts
    vlookup fixed it, just started to play with vlookups after posting :S

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 12-08-2005, 08:50 AM
  2. Rounding to thousands in Excel?
    By johnnr892 in forum Software
    Replies: 1
    Last Post: 15-01-2005, 01:43 AM
  3. Excel spreadsheet fixing tool?
    By joshwa in forum Software
    Replies: 2
    Last Post: 28-10-2004, 11:23 AM
  4. 'Simple' excel help please, merging data..
    By Snow-Munki in forum Software
    Replies: 3
    Last Post: 10-10-2004, 12:14 PM
  5. Quick, boring, excel noob problem
    By klarrix in forum General Discussion
    Replies: 4
    Last Post: 19-07-2004, 07:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •