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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find - match two values 1
vb programing match function 6
Games for 2018 2
Index function using multiple values in one cell 2
Find matching records in two tables using mulitiple criteria 1
index match 3
Match 2 Columns, Return 3rd, Differing Match Types 3
INDEX/MATCH Functions with row-arranged table. 1

Back
Top