Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2013, 11:38 PM
Itsbarbara Itsbarbara is offline Lookup using 2 criteria Windows 7 64bit Lookup using 2 criteria Office 2010 64bit
Novice
Lookup using 2 criteria
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup angie.chang Excel 1 07-27-2012 09:45 PM
Sorting by certain criteria randenius Excel 2 06-11-2012 02:18 AM
Lookup using 2 criteria Possible Lookup Karen222 Excel 3 01-10-2012 05:41 AM
Lookup using 2 criteria LookUp aztiguen24 Excel 5 05-24-2011 03:57 AM
Lookup using 2 criteria Countif with 2 criteria ibrahimaa Excel 3 05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft