Additional formulas..

[vampcatt]

I have about 10 columns of data that I need to have formulas for..
I got a formula from here for column A.. so.. any future formula's cant be the VLOOKUP.

I have the following data to apply to all the text on column D -

shirt =4x
pants =4x
hat =8x
shoes =4x
gloves =8x

X is a constant value dedicated to cell A2 of the "admin" sheet.. all the text is on sheet 2 .

ANy suggestions? Hopefully if I can get this formula going I can use the same format for additional column formulas.

THANKS in advance!

 

[Yogi Anand]

Hi vampcatt:
It is not clear what you are looking for ... please explain what you want to do especially the logic -- then we can work on the associated syntax and the formulas!

 

[Juan Pablo González]

Also, why this ?

so.. any future formula's cant be the VLOOKUP.

 

[Dave Patton]

Your information is not very clear.

What do you put in the 10 columns?

Why can you not use Vlookup?

Can you give a very concise example?

What result do you want to achieve?

What calculation require a formula?

 

[vampcatt]

<<grin>>
OK.. let me get together a little better example with some more info..
I thought Vlookup could only be used on the first column of a spreadsheet?

Let me get my examples together and will repost.. sorry.. lol

 

[Aladin Akyurek]

On 2002-03-23 08:44, vampcatt wrote:


I have about 10 columns of data that I need to have formulas for..
I got a formula from here for column A.. so.. any future formula's cant be the VLOOKUP.

I have the following data to apply to all the text on column D -

shirt =4x
pants =4x
hat =8x
shoes =4x
gloves =8x

X is a constant value dedicated to cell A2 of the "admin" sheet.. all the text is on sheet 2 .

ANy suggestions? Hopefully if I can get this formula going I can use the same format for additional column formulas.

THANKS in advance!

You could make a 2-column list of all items, say, in the Admin sheet:

{"gloves ",8;
"hat ",8;
"pants ",4;
"shirt ",4;
"shoes ",4}

Select all of the cells of this list and give it a name, e.g., FLIST (from factor list).

The usage would be, given that you have,

'shirt' in A2 and 25 in B2 as quantity, you can compute the total in C2 by:

=B2*VLOOKUP(A2,FLIST,2,0)*Price

where Price=X.

Aladin
This message was edited by Aladin Akyurek on 2002-03-23 09:53
This message was edited by Aladin Akyurek on 2002-03-23 09:54