#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thanks Pecoflyer
sample sheet is attached |
#4
|
||||
|
||||
The attached is not entirely foolproof but should get you started
__________________
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 |
#5
|
|||
|
|||
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 |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
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 |
#8
|
||||
|
||||
Another try ?
__________________
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 |
#9
|
|||
|
|||
Nope its still not working, how frustrating. Are you able to post the formula in the message box?
|
#10
|
||||
|
||||
In B4 :
Code:
=SUMPRODUCT((Sheet2!$A$2:$A$7=Sheet1!B$2)*(Sheet2!$B$2:$B$7=Sheet1!B$3)*(Sheet2!$C$2:$C$7)) In B6 : Code:
=INDEX(Sheet2!$E$1:$E$7,(SUMPRODUCT((Sheet2!$A$1:$A$7=Sheet1!B$2)*(Sheet2!$B$1:$B$7=Sheet1!B$3)*ROW(Sheet2!$E$1:$E$7))))
__________________
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 |
#11
|
||||
|
||||
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 |
#12
|
|||
|
|||
Thank you I will give it a try
|
|
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 |