Vlookup & CountA function together?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

acejackhammer

Thread Starter
Joined
Apr 14, 2011
Messages
70
Hello, I have an Excel worksheet with 2 tabs. An employee tab has two columns; location and date. The other tab labeled main locations has all locations and dates. I'm looking to do a vlookup where if the main locations tab has a date in the date column and that location is one in the employee tab then counta all locations that have a date in the employee tab.


So the main locations tab has more locations and input dates than this specific employee tab. Once a date is entered in the main locations tab, if that location matches with the one in the employee tab, counta that date entry.

Any thoughts as to how to write this formula? This is what I had but I get an error message:

=VLOOKUP(A2:A85,'main locations'!A2:A202,COUNTA('main locations'!B2:B202,)*2,FALSE)
formula in the employee tab. Any help is greatly appreciated.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Hi,
As far as I know VLOOKUP only works on single entries, the first found is used, so that will not work, also the list has to be sorted alphabetically, I think something like MATCH en INDIRECT but I'm not tat hot with formula's
Another point, not less important, you forgot to mention the EXCEL version?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top