Thread: Lookup using 2 criteria
View Single Post
 
Old 10-04-2013, 11:38 PM
Itsbarbara Itsbarbara is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Oct 2013
Posts: 8
Itsbarbara is on a distinguished road
Default
I think I love you.

I have worked for hours, and I tried something similar, however, you simplified it for me...and Viola!!!

This worked:
=VLOOKUP(A2&B$1,[Check_IN.xls]EmployeeData!$A$3:$E$1257,5,FALSE)
Reply With Quote