List 1 has card number
List 2 has card number and account
I wasnt to have in a blank cell
"If column A (List 1 card) = Column X (List 2 card) then put here the account number that Card belongs to (which is in list 2)"
The reason I cant do it (using vlookup) is that List 1 has many transactions on a single card sometimes.
__________________
"Do not tell lies, and do not do what you hate,
for all things are plain in the sight of Heaven. For nothing
hidden will not become manifest, and nothing covered will remain
without being uncovered."
The Gospel of Thomas
|