Closed Thread
Results 1 to 5 of 5

Mix of troubles..

  1. #1
    Banned User!
    Join Date
    07-08-2018
    Location
    missouri,usa
    MS-Off Ver
    2013
    Posts
    3

    Mix of troubles..

    Hi All,

    Couple of things i havent been able to get sorted out yet, first if C15 is 50 or less add 1 to D15 and 2 to E15, or if C15 is =51 <75 add 1 to D15 and 3 to E15, etc..

    2nd im trying to pull data from a list of 12 objects on sheet2, i have a ref number to align the data, A15 contains ref number and B15 to L15 (sheet2)contains the the data i want to pull to sheet1 A37 ref number and B37 to N37, i have some rows merged is why its to N, i have tried the =VLOOKUP($A$37,Sheet2$A$15:$E$211,2,FALSE) but as you can tell it only allows the 2 column.. i've been trying indexing but without much luck, any thoughts or ideas' would be great

    3rd if O2 or R2 is Purple,Orange,teal or aqua and H2 is red add(Sheet2-C15 to sheet1-F17),green add(Sheet2-D15 to sheet1-F17),blue add(Sheet2-J15 to sheet1-F17),or tan add(Sheet2-C21 to sheet1-F17) and O4 or S4 is number range 1 to 25 add Sheet2 - B146:B170, hope this makes since... been working on this for the last 2 days and still i suck ....

    thanks for any help
    terry

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: Mix of troubles..

    Welcome to the board.

    Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Banned User!
    Join Date
    07-08-2018
    Location
    missouri,usa
    MS-Off Ver
    2013
    Posts
    3

    Re: Mix of troubles..

    not sure what you are talking about .. i cant see what rules i have broken??

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,210

    Re: Mix of troubles..

    Your post does not comply with Rule 1 of our Forum RULES. 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 go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  5. #5
    Banned User!
    Join Date
    07-08-2018
    Location
    missouri,usa
    MS-Off Ver
    2013
    Posts
    3

    Re: Mix of troubles..

    aahhhh .... bunch of ***** running this forum ... you can delete my account i'll find help else where ....

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using <> troubles in IF Then's
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2015, 02:55 AM
  2. IF AND Troubles!
    By jeffexceler in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-21-2013, 06:01 PM
  3. IF AND troubles
    By theatricalveggie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2013, 05:09 PM
  4. [SOLVED] If - Then - else troubles
    By DFrank231 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 12:35 PM
  5. Excel 2007 : Having Chart troubles
    By Jstapel in forum Excel General
    Replies: 0
    Last Post: 03-07-2012, 11:03 AM
  6. Troubles with ROW
    By aikorei in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 04:24 PM
  7. rounding troubles
    By joshuapiper in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-24-2008, 03:16 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1