Search results

Hi Hui, I feel dumb. Sorry about that, totally missed it. I was thinking one thing and did another. I have been lately spending too much time in front of the screen inputting data and I’m starting to miss the obvious. I made the correction and it works. Thank you so much for your help, I...

Hi Hui, Thank you for the feed back. I did what you wrote and fixed that problem but now once I have done everything above I get a Circular Reference Warning. And when I copy across and down I get - in most cells and 0 in some. I emailed the updated file to you for reference. This formula is...

Hi Hui, Thanks for taking look at this. I did what you wrote but when I copy down and across all I get is - in each cell. Am I missing something i.e. am I supose to replace the "-" with cell references?...still new to excel but I'm learning. Thanks for taking your time helping me.

Hi Luke thanks for looking into my problem. I think I got you a bit confused as to what it is i'm looking for. Sorry! I'm going to try to explain it again. Sheet1: __A, B, C, D, E, F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V 1_2006.09.24,True,1.4561, 1.4457, 1.4513...

Hello, I need help creating a function that will allow me to do the following: IF B1 shows true then I want the cells B2 to B21 show values from data range in another worksheet (i.e. B2 will show value from sheet5 C1, B3 will show value from sheet5C2, etc.. till the 20th value) Also, this is...

Thank you. That was it. I foregot about it since I first constructed the formula for "L" only and once it worked I included the second half for "S" but I didn't realize the 0 at the end of "L" ifs would cause an issue. Thanks again!

Hello, I have created the below formula but excel (2010 version) is telling me that I used too many arguments. When I had it for "L" only it accepted the argument. So right now I'm facing with one option and that is spliting up "L" and "S" between two target cells. Is there a way I can make...

Thank you. I'm learning a lot here.

Perfect! The second formula is exactly what I was looking for. Thank you!!! I'm learning a lot by trial and error and it's great to have this forum as a resource. One thing I just learned that in order for the lookup to work, values must also be ascending both in vector and array otherwise...

ok the below formula is what i thought might resolve my problem i.e. if a particular text appears in B9 then a specific assigned value will appear in C9 but it doesn't work. What am I doing wrong???? The B9 is a drop down list from which I can pick specific text code and all I want is for the...

sorry let me paint the scenario a little bit better. A1 is a dropdown list which gives me option L or S only. B1 is a dependent dropdown list on A1. If in A1 I choose L then in B1 a dropdown list only from D1:D10 shows up from which I can choose a value. If S is chosen in A1 then in B1 a...

I need to create a formula where a cell will show me a value based on the values in two preceding cell. I have been looking throughout this forum including archives and could not find anything similar to this. I am currently working on a model and the below formula would address most of my...

Thank you so much. This is exactly what I was looking for and problem solved!!! I guess being knew it will take me some practice navigating and knowing what key words to use to search for posts. Thanks again.

I'm trying to set up a drop down list where there are two sources and depending on the value shown in Column A cell the respective data source is chosen/made available in the drop down list in a cell of Columne B... i.e. ****** if Cell A9 shows value of L then Cell B10 shows drop down list...