How to match text and return value in adjacent or next cell?

Copper Contributor

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.

On 2 Jan, I should get 34.5.

01-JanWTM33.1AZB25.6CAB19.9DAL8.2JSM6.6SIB3.3KIM1.1
02-JanCAB35.9WTM34.5AZB20.5DAL4.3KIM1.2SIB1.0DUS0.7
03-JanCAB35.9WTM34.5AZB20.5DAL4.3KIM1.2SIB1.0DUS0.7
04-JanCAB31.1WTM25.9AZB20.6DAL5.6BUO4.4JSM3.9SIB3.6
05-JanCAB26.2AZB20.6WTM17.3BUO8.8JSM7.8DAL6.8SIB6.3

 

Thank you all for support.

2 Replies

@Pisut 

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.