In D column in GENERAL sheet I need to get values from JAN sheet based on customer number and product number. sample worksheet attached.
In D column in GENERAL sheet I need to get values from JAN sheet based on customer number and product number. sample worksheet attached.
try
=INDEX(JAN!D:D,MATCH(GENERAL!A2&GENERAL!B2,JAN!A:A&JAN!B:B,0))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Tnx for reply, in this table works perfectly but in my original table wont work, don't know why.
can you post a sample of the original table, with sensitive data cleared out ?
here it is...
you have @ in the formula
=INDEX(jan!F:F,MATCH(gen!A12&gen!B12,@jan!A:A&@jan!B:B,0))
change to
=INDEX(jan!F:F,MATCH(gen!A12&gen!B12,jan!A:A&jan!B:B,0))
then works OK
oh
does this work ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks