CODEWITHSUNDEEP
excelexcel-formula
jkupczak
jkupczak

Reputation: 3031

Can I use match() with offset() in Excel?

I'm using match() to locate a cell with a specific value in column A.

=MATCH("Sales",A:A,0)

This returns the row value 40 for example.

I want to then use this value with OFFSET() like so:

=OFFSET(MATCH("Sales",A:A,0),1,1)

So if my match() returned A40, offset() would then give me the value of B41. Unfortunately, this does not work. What can I do to achieve this?

Upvotes: 0

Views: 1651

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Use INDEX instead:

=INDEX(B:B,MATCH("Sales",A:A,0)+1)

OFFSET is volatile and should only be used when no other option is available.

Upvotes: 3

Related Questions