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

Hi

I don't really understand your column organization ( a sample workbook might help), but the result is something along the lines of =SUMPRODUCT((Sheet2!A1:a100=A1)*(sheet2!A1:a100=B1 )*Sheet2!C1:C100)

Of course as you are suing dates there might be some surprises, so posting a book will certainly help

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Pecoflyer

sample sheet is attached

Attached Files

sample excel.xlsx (10.0 KB, 7 views)

The attached is not entirely foolproof but should get you started

Attached Files

sample.xlsx (10.5 KB, 19 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi

I could not open this version of excel on my computer, are you able to resend or post the formula

Thank you for you help

You are probably experiencing the same as some members do on this forum when downloading a file (not everybody does according to admin). It adds an xls extension to the existing xlsx extension.
Instead of opening the file from the web, first download and save it then open it from your PC

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi just tried that, it trys to save it as a PHP file and doesn't allow me to change. This file will not open

Thanks

Another try ?

Attached Files

sample.xlsx (10.5 KB, 14 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Nope its still not working, how frustrating. Are you able to post the formula in the message box?

In B4 : drag right and down ( only for row 5)

In B6 : and drag right

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Perhaps contact admin to examine your download problem?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you I will give it a try