Need to look up all three values and the corresponding month number into the output cells:
Values in the cells C19, D19, E19 are changeable based on the user input:
Attached is the spreadsheet, I need to populate the output cells with the value based on the selection in cells C19, D19, E19 and the corresponding month number column B (as well) from the table with all the values corresponding to C19, D19, E19. Please take a look. Thanks in advance.
Try this
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
I cannot use "SUMPRODUCT" function, is it possible to achieve it using vlookup? Thanks.
Why not???I cannot use "SUMPRODUCT" function
My Software has limitations because I am using the results from this excel to feed another software's input.
So I am unable to use SUMPRODUCT, I already have the formula but it didnt work for me if I use SUMPRODUCT or SUMIF or INDEX, MATCH. Tried all of them but I am limited to Vlookup or Hlookup at this time.
Can you please provide an alternate. Thanks.
I agree with pop...why cant you use sumproduct()?
The would be the INDEX/MATCH version, ARRAY entered...
=INDEX($A$2:$R$15,MATCH($C$19&$D$19,$B$2:$B$15&$D$2:$D$15,0),MATCH($E$19,$A$2:$R$2,0))
If you are inssistant on using vlookup, insert a helper column after "Network" and copy this down...
=B3&D3
Then your vlookup would be...
=VLOOKUP($C$19&$D$19,$E$2:$S$15,MATCH(F19,$E$2:$S$2,0),0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Or maybe a pivot table can help you?
I am getting the following error #N/A when I try the below formula: Can you please check. I cannot use MATCH eighter only Vlookup. Thanks.
If you are inssistant on using vlookup, insert a helper column after "Network" and copy this down...
=B3&D3
Then your vlookup would be...
=VLOOKUP($C$19&$D$19,$E$2:$S$15,MATCH(F19,$E$2:$S$2,0),0)
why not? Is this a homework assignment?I cannot use MATCH eighter only Vlookup.
I truly do not understand why you cannot use sumproduct of index/match? They would both produce an answer that would be exactly the same as vlookup(), but would be far simpler to use. If your software can use the answer from a vlookup, I cannot see what it cannot use the answer from the others
Last edited by FDibbins; 02-03-2014 at 12:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks