I have attached an example. on the "master" sheet in column L I need a vlookup which will look up the information in column I & J and return the appropriate amount for that from column C of the "sheet3" tab. If there is nothing it should just return 0.
Can someone please help me.Sample Macro jscalem.xlsx
Enter as an array formula confirmed by Ctrl+Shift+Enter
=INDEX(Sheet3!$C$2:$C$7,MATCH(I2&J2,Sheet3!$A$2:$A$7&Sheet3!$B$2:$B$7,0))
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
L2 and drag it down
Please Login or Register to view this content.
You don't need an array or VBA - SUMIFS would accomplish exactly what you need:
=IF(ISERROR(SUMIFS(Sheet3!$C:$C,Sheet3!$A:$A,Master!$I2,Sheet3!$B:$B,Master!$J2)),0,SUMIFS(Sheet3!$C:$C,Sheet3!$A:$A,Master!$I2,Sheet3!$B:$B,Master!$J2))
See attached
Need to add a helper column in sheet2 to concatenate the lookup
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks