Another dumbass Excel question

Post by **Mop** » Mon Sep 20, 2004 12:06 pm

Thanks in advance,

I am trying to learn ' if then', other uses for excell at the moment

So I have two different forms the first on is there to track sales

The second to track commission

What I am looking to do is from sheet one pull the name to sheet two with the amount that was paid - IE

Robert Brown sold 5 hours
Mike sold 3 hours
I sold 2 hours

The commision sheet would then pull Robert brown - 5 hours - x amount sold (which can all be found on the sales sheet)

i dont understand if then statements.

Please help~

Menlaan · Post by **Menlaan** » Mon Sep 20, 2004 2:26 pm

It sounds like what you want is a "lookup" function that will pull data from one sheet into the other. Using vlookup you can find the hours from the previous sheet where the Name equals "Robert Brown". Would something like that help you?

Menlaan

Post by **Mop** » Tue Sep 21, 2004 9:31 am

How would I go about a Vlookup equation

Menlaan · Post by **Menlaan** » Tue Sep 21, 2004 9:58 am

Syntax: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

put something like "=vlookup($A1,SalesSheet!$A$1:$B$20,2,FALSE)"

What this will do is find the row on SalesSheet where Column A matches the value in $A1 on the current sheet. It will then return the 2nd column of that row on SalesSheet.

If your data is arranged differently, you can expand the range that it is referencing and change you col_index appropriately.

If this is along the lines of what you're looking for, let me know and I can help you with your specific problem.

Menlaan