match function for 2 values

  • Thread starter Thread starter Tomo
  • Start date Start date
T

Tomo

SPRING/SUMMER JANUARY Red Tab Guys 005010234 30 2
SPRING/SUMMER DECEMBER Red Tab Guys 005040037 32 4
SPRING/SUMMER DECEMBER Red Tab Guys 005040037 34 6


How to find with visual basic code or match function in witch row and
column is data with
match 005040037 and 34,
or in this case 3rd row??

Tnx in advance!
 
Something like this will work:
=ADDRESS(MATCH(A6,A1:A4,0),MATCH(A7,A1:H1,0))


Regards,
Ryan--
 
You have replies at your other posts.
SPRING/SUMMER JANUARY Red Tab Guys 005010234 30 2
SPRING/SUMMER DECEMBER Red Tab Guys 005040037 32 4
SPRING/SUMMER DECEMBER Red Tab Guys 005040037 34 6

How to find with visual basic code or match function in witch row and
column is data with
match 005040037 and 34,
or in this case 3rd row??

Tnx in advance!
Click to expand...
 
Back
Top