| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function won't recognize values unless I type them | Excel Worksheet Functions | |||
| Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Hybrid Mode
