need look value in B6 in attendance sheet that matched from waiting list sheet
need look value in B6 in attendance sheet that matched from waiting list sheet
something like this?
=INDEX('Waiting list'!$E$2:$E$7,MATCH(B2,'Waiting list'!C2:$C$7,0))
or
=IF(INDEX('Waiting list'!$A$2:$A$7,MATCH($B$2,'Waiting list'!$C$2:$C$7,0))=$B$1,INDEX('Waiting list'!$E$2:$E$7,MATCH(B2,'Waiting list'!C2:$C$7,0)),"")
with checking Batch no. and Product name
Last edited by sandy666; 07-05-2017 at 02:32 PM.
work good
than you very much
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Done........................................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks