I am trying to set up a way to confirm commission payment on a particular
account.
I have a spreadsheet with orders that we have placed with the main company &
then when the statement comes back to us from the main company that lists
what accounts the company has paid commission on I need to have a way to
compare a spreadsheet that contains commission paid on order numbers to my
spreadsheet that contains order numbers placed. I am thinking a vlookup is
the way to go but I am not sure.
Thank you for any help. (I am definately a newbie but I work for a very
small company & am having to wear many different hats right now & we are
growing & I need to find a way to work smarter rather than harder!)

One of the stipulations of using the Vlookup() function, is that the column
containing the lookup value is to the *left* of the column containing any
data that you want returned from the corresponding row.

If this is not the case, then a combination of the Index() and Match()
functions can perform the same task.

Here's a link to Debra Dalgleish's web page concerning Vlookup:

http://www.contextures.com/xlFunctions02.html

Post back with the configurations of *both* your WBs if you need more help.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"OBJ" wrote in message
...
I am trying to set up a way to confirm commission payment on a particular
account.
I have a spreadsheet with orders that we have placed with the main company
&
then when the statement comes back to us from the main company that lists
what accounts the company has paid commission on I need to have a way to
compare a spreadsheet that contains commission paid on order numbers to
my
spreadsheet that contains order numbers placed. I am thinking a vlookup
is
the way to go but I am not sure.
Thank you for any help. (I am definately a newbie but I work for a very
small company & am having to wear many different hats right now & we are
growing & I need to find a way to work smarter rather than harder!)