I've got two reports, pulled in as separate sheets in one excel file. This is the approach I came up with, but I don't know how to implement it:
- For each cell in column "merchant_name" in sheet 1, find the cell with the matching value in the "merchant_name" column in sheet 2. (This will be a one-to-one relationship.)
- Identify the row for the found cell
- Check this row for the value of the "rank" column
- Print the found "rank" column value to the "rank" column row in sheet two that corresponds with the matched merchant_name value.
...does that make sense? If someone could help me understand what functions these would be to google and try to piece together a formula, that would be uber helpful also.