Hi,
I have a lot of data that i need to get a formula for.
I need help with populating column I.
I have tried many options but not getting anywhere.
I am trying to get back the credit card number (column I) if the transaction date is within the Table last purchase date and card status date matches the employee ID (Column G and column B) then come back with the credit number.
Any help will be greatly appreciated.
Bookmarks