Alright, so im making an excel sheet to track the measurements for my company, Im attaching it here at:
http://www.2shared.com/document/1FdLvFh1/mattsexcelproblem.html
Although here is a more basic explanation
I have a manually entered value for each entry, lets say the first one is "500"
Following that, I have multiple drop downs on a list such as:
-used, new, broken
-red, green, blue
-car, boat, plane
**at the bottom there is the concatenate function to join them all together**
so the person just uses the drop down to choose a combo that could lead to something like -- new green boat OR broken red car
and before they did that, they manually entered a value for that case, lets say 500
now on the following page, there is an assigned value for each so for example:
new green car | 25
used red plane | 95
broken blue car | -15
Now Im using the vlookup function so that on a cell, it references the concatenated result, and (hopefully) returns that value
on top of that, I add the beginning value to it, so 500 is added against the number
lets say they broken blue car at -15, + 500 = value of 485
well, I just cant seem to get this to work, although Im going back and forth on my sheet so much!!!
any help or advise is appreciated
below are the formulas for those who dont want to look at the page
now for whatever reason, it always seems to only go on whats at cell Q22 on that worksheet, is is possible that the concatenate function doesnt work all that well with vlookup?
for those who are looking at my page, Im only using OP1 in columns C15:C29 to combine all the data and the final version which is concatenated is on cell C30 on the first page called DATA
the second page is cutcard2 and its B3 whereupon Im stuck
thanks for any help on this, Ive been stuck for such a while now
http://www.2shared.com/document/1FdLvFh1/mattsexcelproblem.html
Although here is a more basic explanation
I have a manually entered value for each entry, lets say the first one is "500"
Following that, I have multiple drop downs on a list such as:
-used, new, broken
-red, green, blue
-car, boat, plane
**at the bottom there is the concatenate function to join them all together**
so the person just uses the drop down to choose a combo that could lead to something like -- new green boat OR broken red car
and before they did that, they manually entered a value for that case, lets say 500
now on the following page, there is an assigned value for each so for example:
new green car | 25
used red plane | 95
broken blue car | -15
Now Im using the vlookup function so that on a cell, it references the concatenated result, and (hopefully) returns that value
on top of that, I add the beginning value to it, so 500 is added against the number
lets say they broken blue car at -15, + 500 = value of 485
well, I just cant seem to get this to work, although Im going back and forth on my sheet so much!!!
any help or advise is appreciated
below are the formulas for those who dont want to look at the page
Code:
=CONCATENATE(C26," ",C25," ",C24)
Code:
=VLOOKUP(DATA!B30,P10:Q52,2)+DATA!C19for those who are looking at my page, Im only using OP1 in columns C15:C29 to combine all the data and the final version which is concatenated is on cell C30 on the first page called DATA
the second page is cutcard2 and its B3 whereupon Im stuck
thanks for any help on this, Ive been stuck for such a while now
