Coupon Usage Report

Paul C 50

New Member
Joined
Mar 20, 2019
Messages
3
I have a downloaded report in Columns A through L and a listing of activities in columns P through Q. On the report, I am trying to match the descriptions in Column C with the listing of activities in Column P and then entering the account number in Column R to the appropriate cell in Column D> I have tried V LOOKUP and IF, THEN, but I am either writing them wrong or there are too manty operations.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,414
Could you share some sample data? Either use the table function in the advance reply or upload a file to a sharing service (eg. Dropbox).
 

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,414
Click the Table Icon, enter the number of rows and columns, create it and insert some data
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top