LinkBack URL
About LinkBacks
Or this non-array formula with a helper column...
in sheet1 D2, copied down...
=B2&A2
Then on sheet2...
=INDEX(Sheet1!$C:$C,MATCH(Sheet2!$C$1&Sheet2!$C$2,Sheet1!$D:$D,0),1)
entered in the regular way
Or this non-array formula with a helper column...
in sheet1 D2, copied down...
=B2&A2
Then on sheet2...
=INDEX(Sheet1!$C:$C,MATCH(Sheet2!$C$1&Sheet2!$C$2,Sheet1!$D:$D,0),1)
entered in the regular way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks