Steven

So, I'm tying to create a dropdown list in Word whose contents is that of either (a) a dropdown list already created in a separate excel document that can, and will change throughout these documents' lives, or (b) create it's own dropdown list...referencing the table rather than the already existing dropdown list itself.

Is there a way to do this that doesn't involve VBA programming skills?

Here's the formula I'm trying to extend. It makes it's own sequence and has it's own idea of the pattern...is there a way to manipulate the pattern so it's changing the correct formula values?

Cell B3=VLOOKUP(B2,'Copy of Book2'!A2:B19,2,)

Cell B4==VLOOKUP(B2,'Copy of Book2'!A2:C19,3,)

It adds 1 additional column to the table array, and 1 to the column index number.

Excel tries to move the table array down 1 cell since that's where I've gone...I've tried making up to 4 or 5 of the proper formula manually, and it still doesn't pick up on the pattern.

Suggestions?

So...I can t figure out how to ask the internet best, so let s see if people know!

Here s the formula:

Cell B3 =VLOOKUP(B2, Copy of Book2 !A2:B19,2,)

Cell B4 =VLOOKUP(B2, Copy of Book2 !A2:C19,3,)

The end destination cell increases by 1 column, and the column index number increase by 1, whilst everything else remains the same.

Even when I continue the pattern in multiple cells, it doesn t pick up on my pattern and makes it s own computer-logic pattern. Stupid thing doesn t read my mind. Is there any way I can reprogram is pattern logic to fit the bill here?

In my experience, you can t, you just have to think more for the computer, so I will take that as well.

Thanks!

I have a briggs and stratton 10t802 0778 b1 lawnmower. It starts, runs great for about 2 seconds and cuts off. I m using fresh gas, it has a new spark plug, gas tank, carburetor, oil, air filter and governor spring. I have no idea what else to do. I checked for proper air flow from the gas cap too. Help?