Vlookup two columns return 3rd

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup two columns return 3rd

FAQ

Thread Tools

Display Modes

01-10-2014, 12:32 AM

jennamae

Windows 8

Office 2010 32bit

Novice

Join Date: Nov 2013

Posts: 9

Vlookup two columns return 3rd

Hi,

I have two vlookup functions on sheet 1

I would like it to search the date I have typed in A1 sheet 1 and the shift I have entered in sheet 1 B1 and return a result of data in C1

Sheet two is where the data is stored and has the below information

Date - Shift - Workers On
11/1/14 - DAY - 5

Therefore if in sheet 1 in A1 I enter the date and in sheet1 B1 I enter D, C1 will return 5

Please help

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to return to a PPT after opening a PDF in the PPT	sasquachnw	PowerPoint	0	05-03-2012 07:02 AM
Return Entire Row	ibrahimaa	Excel	3	01-10-2012 05:44 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
Return to in box	cjwilson2740	Outlook	0	04-05-2010 02:27 PM
Carriage Return Help	UCHelp	Word	1	04-04-2010 10:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.