Hello Experts,
How can I use an IF/THEN formula to return data that is 2 cells to the right of the match?
Example:
If any cell between columns E:DA equals the word "color", return data from cell two cells to the right
The hard part is, I'm not able to be specific about which cell I'm matching to because the attributes that I'll be matching aren't sorted. They're spread out across many columns. The formula I'm in need of will have to span columns E:DA.
I've attached an example, it's a small sample size of 8 products out of the 10k SKUs that I'm working on.
Thank you very much in advance,
Matt
Bookmarks