Hi there,
Pretty new here, was wondering if someone can help me design a formula for example i got dates and flights in two work sheets A and B.
I want formula to check date and flight number in Sheet A and B and than copy over Invoice amount in Sheet B to Sheet A column D, Column C will have Accruals present already.
Thank you in advance.
Hi deadshine,
I think vLookup will do so. Can you upload a sample workbook, with expected result(manually).
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
hi there,
Uploading sheet i am working on,Sorry if it looks confusing. I am trying to keep it simple for my non excel user collegues.
Hi deadshine ,
Clarify something with you.
lookup the date(APM Accruals - Col A) and Flt no(APM Accruals - Col E),
if match with sheet("Invoice Sheet"), then return value to invoice Amount (APM Accruals -Col G).
Am i correct?
And there are 3 match, same date and same flt no, but diff invoice amount.
yes 3 matches, Same date and flight but different amounts as one amount is what we assumed and other is what supplier put on his invoice.
Book1(Edit v1).xlsm
Hi deadshine,
Sry for the late reply. Im on holiday.
Please find attached file.
below is the code i'm using, please enter the code and press CTRL + Shift + Enter, instead enter only.
For those return #N/A, is because the column E value recognize as text, is not match with Invoice Sheet which is number.
Let me know if you have problem with the code.
=INDEX('Invoice Sheet'!$C$2:$C$295,(COUNTIFS($A$2:A2,A2,$E$2:E2,E2) -1) + MATCH(1,(TEXT(A2,"DD.MM.YY")='Invoice Sheet'!$A$2:$A$295)*(E2='Invoice Sheet'!$B$2:$B$295),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks