hi all
im wondering if someone can help
I run 2 documents at work which show slightly different results for the same orders - I need to see figures from both file dumps
so ive dropped them into excel on tab 2 and 3 - currently I have managed to get formulas on tab 1 so it pulls info from tab 2
what I require is for column J ( tab 1 ) to show the figure from column I in tab 3 when the number in column A tab 1 matches column E in tab 3
hopefully that all makes sense - I have written an example in the spreadsheet
thanks in advance
Bookmarks