Verify if Acct # that is on wksheet is on another

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I have a main worksheet with all available accounts. I want to see if there
are accounts on my other worksheets that are already on my main worksheet.

Thanks,
 
Hi Donna,

A quick way is to use the vlookup (vertical) formula, which looks for an
match and returns whatever you want returned in your array. If not found the
result would be #N/A, which would be any that are not on your main worksheet.
There is also a hlookup (horzontal). If using the function wizard, it will
describe exact what is needed, step by step. Excel help also will explain
well.

Hope this helps, once you are comfortable with lookups, you will find you
use them very frequently.
 
Back
Top