Thanks:  0
Likes:  0

1. 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.

2. 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!

3. Also, why this ?

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

4. 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?

5. <>
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

6. 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.

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.

[ 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 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•