Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Another Approach to Vlookup? (excel 2000)

    There is no sheet named "Sand" in the workbook you attached, I assume that you mean ProppantSchedule.

    What do you want to accomplish? Doesn't VLOOKUP do what you want? Please try to be specific.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Approach to Vlookup? (excel 2000)

    Without having a lot more specific question, the only suggestion that I would have would be to change your formulas like this one from B11 on sheet ProppantSchedule:

    <code>
    =VLOOKUP(A11,Fluidlist,2,FALSE)
    [/code

    to something like this to eliminate the #xx errors:

    [code]
    =IF(ISERROR(VLOOKUP(A11,Fluidlist,2,FALSE)),"",VLO OKUP(A11,Fluidlist,2,FALSE))
    </code>
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another Approach to Vlookup? (excel 2000)

    Yes V lookup does accomplish what I want. however Iam doing
    columns F and G in two steps and I think I could do it in One but have no I dea how to code a function to do it.


    I would also like to make column function like this:
    if sf1 is typed then that give you the fluid used for the sand1fluid stage.
    I would like this to continue down column a until sf2 is typed which changes the fluid.
    this can be accomplshed using auto fill, but the people using this workbook dont know how to use it.

    so when sf1 is typed in column a21 it autofills to a43. when sf2 is typed in cell a22 it then autofill a22 to a43
    the when sf3 is typed in a27 it fills to a43 and so on.

    I have update the worksheet example

  4. #4
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Another Approach to Vlookup? (excel 2000)

    I am doing a worksheet which has a goal to be auomated.
    I have attached a worksheet and have made an approach to automaing my worksheet(sand)

    On the INPUT sheet I have tom combo boxs from cells b89 to b98. THey all contain information from the same list.
    te diferent is stage which have different fluids.

    After the user selects all the required fluids for each stage they can go to the Sand tab.

    here is where I have use VLOOKUP in columns B, C and F,g

    I have done this so the user can specify what they want for each stage. using a short easy abreviation to fill out this
    work sheet.

    I have used Vlookup to its fullest and think that I should be using maybe a different function.

    does anyone have any good ideas?

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Another Approach to Vlookup? (excel 2000)

    In C11 (eg) you could use a combined formula instead of what you ahve and not use the intermediate calc:

    =VLOOKUP(VLOOKUP(A11,Fluidlist,2,FALSE),FluidEntry s,2,FALSE)

    Instead of "autofill" you could use a function In A22 enter:
    =a21
    and copy it down the column. Then when the change A21 all will be changed below it.then they just have to change the ones they want. The problem is once they eliminate the formula by entering a value, the formula goes away. You would have to use a macro or some other formulas, but I am not sure exactly what you are after. Is there a pattern when the items are to change and what they should be?

    Steve

Posting Permissions

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