-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
match 2 rows
-
A
Row Number with Match with two criteria
I want to know the row number matching two values in two columns. SHEET 1 ↓↓↓↓ COLUMN 1 COLUMN 2 COLUMN 3 A 1 B 2 B 1 SHEET 2 ↓↓↓↓ COLUMN 1 COLUMN 2 COLUMN 3 A 1 I want the row number HERE from sheet1 B 1 Here result should be 3 Do you know any formula which I can...- asolopreneur
- Thread
- match 2 columns match 2 criteria match 2 rows
- Replies: 4
- Forum: General Discussion & Other Applications
-
Look for offset value to the left from an array after only satisfying the match criteria of two sets first.
Hi Excel Guru's, trust everyone is well today!!!.... I have been an avid reader of this excellent forum for a number of years and am a huge fan of Bill Jelen and Mike Girvin' work.....they have saved me many, many times. I can say the same for the many posters on this website who have also...- ProgramUser
- Thread
- index & match lookup match 2 rows multiple arrays offset
- Replies: 5
- Forum: Excel Questions
-
D
Cant get Vlookup to work correctly
Hi I am trying to match 2 lists together to see if same order numbers from COLa exist in COL B I have been battling with this for hours and everytime it looks good I sort by N/A and some of the items in COl A still exist in COL B but it sayd N/A. please see sheet attached any help is...- dtavangar
- Thread
- excell match 2 rows vlookup
- Replies: 7
- Forum: Excel Questions
