(Updated 2) Posted/Under Posted amount compare between PC Sorted and ERP Sorted Values
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.
Last edited by ipi99; 03-06-2015 at 03:36 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By ipi99 in forum Excel Formulas & Functions
Last Post: 03-06-2015, 09:54 PM
By ipi99 in forum Excel General
Last Post: 03-06-2015, 12:43 PM
By RVT in forum Excel General
Last Post: 11-05-2013, 08:37 AM
By rrawlings in forum Excel General
Last Post: 05-06-2013, 06:28 AM
By tallflower24 in forum Excel Formulas & Functions
Last Post: 04-22-2013, 12:13 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1