Thank you in advance.
Currently i use the formula below to match data from one worksheet to the next.
I look at the data in column AQ, if it exists on my other worksheet (Adobe Report) in column I i return the result form Adobe Report column D.Please Login or Register to view this content.
Now i have another level of complexity. If the data in the original worksheet in either colums A, AQ or AR appears in Adobe Report column I, I still want to return the result in column D.
Basically, how to i make Excel compare the data in three columns rather than one?
Bookmarks