Forum Discussion
How to match text and return value in adjacent or next cell?
I am working on reporting. How can I match text and return value in adjacent or next cell? For example, I want to match "WTM" on each day and return value next to it. On 1 Jan, I should get 33.1. ...
Try this:
=XLOOKUP("WTM",B1:N1,C1:O1)But it is better the change the structure of your data:
Date - Category - Value
This enables you to use SUMIFS(), COUNTIFS() or pivot table or just filter or sort.
Detlef_Lewin I really appreciate your help. This help me a lot.