Use the vlookup function, if you provide more information or an example it
will be easier to give you detail on how to set it up or if you prefer read
the vlookup function related help .



--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Joanne" wrote:

I'm trying to compare account numbers from two worksheets on a monthly basis,
and then return a value for a second account number in the second worksheet.
The account numbers vary each month. Thank you.