LinkBack URL
About LinkBacks
Try this -
$M$10:$Q$10,OFFSET($L$11,MATCH($E$6,$B$12:$B$26,0),MATCH($B$6,$C$11:$G$11,0),1,1),IF($C$6=$R$10:$V$10,OFFSET($Q$11,MATCH($E$6,$B$12:$B$26,0),MATCH($B$6,$C$11:$G$11,0),1,1)))))
Please find attachment
Try this -
$M$10:$Q$10,OFFSET($L$11,MATCH($E$6,$B$12:$B$26,0),MATCH($B$6,$C$11:$G$11,0),1,1),IF($C$6=$R$10:$V$10,OFFSET($Q$11,MATCH($E$6,$B$12:$B$26,0),MATCH($B$6,$C$11:$G$11,0),1,1)))))
Please find attachment
Last edited by shivya; 11-08-2017 at 01:06 PM.
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
Thank you for your help, I really appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks