Mix of troubles..

1. 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. Re: Mix of troubles..

Welcome to the board.

Thanks.

3. Re: Mix of troubles..

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

4. 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.

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. Re: Mix of troubles..

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

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

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