Can any body help me ?
In Vlookup, we select one criteria of the source worksheet & then compare it with the other sheet.
Is it posisble to compare more than one criteria of the source sheet with another sheet ?
Thanks
Mani
Can any body help me ?
In Vlookup, we select one criteria of the source worksheet & then compare it with the other sheet.
Is it posisble to compare more than one criteria of the source sheet with another sheet ?
Thanks
Mani
Last edited by Shadmani; 07-21-2009 at 08:10 AM.
You'll need to be more specific. Probably best way is to upload an example excel workbook.
Please find the attachment. I need to key in the Marks of English in sheet2 from Master data...
Two criteria need to be checked. Name & Initial..
Please see the attachment...
try in E2 sheet 2
=INDEX(mASTER!$E$3:$E$9, MATCH(A2 & B2, INDEX(mASTER!$A$3:$A$9 & mASTER!$B$3:$B$9, 0), 0))
dragged down
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks That's wow....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks