View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gunti Gunti is offline
external usenet poster
 
Posts: 58
Default Match multiple cells

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