The reason i'm using match is because i'm using the value which comes out of
it for offset..

For example i fill in 5000_001

It has to look for 5000 in column a, 001 in column b and give me back value
x in column C


"Mike H" wrote:

Try

=COUNTIF(A1:A5,"5000")+COUNTIF(B1:B5,"005")

Mike


"Gunti" wrote:

Hi,
I've got the following list:

A B
4999 005
5000 001
5000 003
5000 004
5000 005

I want Match to both find 5000 in column A and find 005 in column B,
returning 6 in this case.

Is this possible?

greets