Posted/Under Posted amount compare between PC Sorted and ERP Sorted Values

[ipi99]

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.

Thanks

 

[Joe4]

Cross-posted: (Updated 3) Posted/Under Posted amount compare between PC Sorted and ERP Sorted Values

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.