ExcelBanter - match function for 2 values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - match function for 2 values (https://www.excelbanter.com/excel-worksheet-functions/172686-match-function-2-values.html)

Tomo

match function for 2 values

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!

ryguy7272

match function for 2 values

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

Regards,
Ryan--

--
RyGuy

"Tomo" wrote:

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!

Dave Peterson

match function for 2 values

You have replies at your other posts.

Tomo wrote:

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!

--

Dave Peterson

All times are GMT +1. The time now is 08:42 PM.