Hi All,
I need to figure out a vlookup function that searches for two variables and return an answer. such as the example attached;
vlookup -- 12253 & 605.34 (if these are matching then) 131001
Hi All,
I need to figure out a vlookup function that searches for two variables and return an answer. such as the example attached;
vlookup -- 12253 & 605.34 (if these are matching then) 131001
IF you got numbers to return you can use:
=SUMPRODUCT(--($E$3:$E$6=A9),--($G$3:$G$6=B9),--(F3:F6))
Test(1).xls
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Or this
**Enter as an array formula (Ctrl+Shift+Enter) combination
=INDEX($E$3:$E$6,MATCH(A9,$D$3:$D$6&$F$3:$F$6,0))
Last edited by AlKey; 12-09-2013 at 11:57 AM. Reason: Added Excel file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi I'm trying to do it on my workbook from two different sheets but is not working see attached
Ranges must be equal
=SUMPRODUCT(--(Workings!D10:D431=G8),--(Workings!K10:K431=T8),--(Workings!F10:F431))
BTW tthere will be now amtch as you have got -600 in collumn K on Workings tab
Just tested this:
Must be entered with Ctrl-Shift+Enter combination.
=INDEX(Workings!$F$10:$F$32,MATCH(G8&T8,Workings!$D$10:$D$32&'60200600 Workings'!$R$8:$R$32,0))
@ lydiaOi
Essayez votre message ici Non English Excel et utiliser le bouton New Thread (Nouveau Sujet)
Ne pas le spam.
Last edited by sandy666; 03-15-2016 at 09:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks