Hello guys I have a condition that I'm trying to get my based on ERP# that posted amount should be appear in front of posted/under ERP# to know that which ERP#'s Amount has been posted and which is remaining Please help me to solve my problem.
I tried =VLOOKUP(B4,F:G,2,0)
but result is coming as below...
waiting for your kind advice and attentions and reply highly appreciated.
Sample sheet attached.