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
Bookmarks