Forum Discussion
Match Cells on Sheet 1 & 2 and return value from a cell on Sheet 2 to a new cell on Sheet 1
Sheet 1, Column B lists names. Same names are listed multiple times. Sheet 2, Column A lists one name and Sheet 2, Column B lists phone # for corresponding name. If the name in Sheet 1, Column B ...
Perhaps it shall be
=IFERROR( INDEX( Sheet1!$G$1:$G$3347, MATCH( MemberData!$A$44, Sheet1!$B$1:$B$3347,0)),"")
SergeiBaklan Can you help me with my issue too?
I only want to display companies from sheet one on sheet 2 that have a match for cell A1 on sheet 2.
Sheet 1 last column, =IF(ISNA(MATCH(C2,{"abc","abc1","abc2","abc3"},0)),"-",MAX(I$1:I1)+1)
| Date | serial number | company | Review Date | Status | ||||
| 5/1/2018 | B12345 | ABC | 5/1/2018 | Accepted | 1 | |||
| 5/2/2018 | B23456 | ABC1 | 5/2/2018 | Consider | 2 | |||
| 5/3/2018 | B34567 | ABC2 | 5/3/2018 | Compare Elsewhere | 3 | |||
| 5/4/2018 | B45678 | ABC3 | 5/4/2018 | Rejected | 4 | |||
| 5/5/2018 | C12345 | ABC | 5/4/2018 | Accepted | 5 | |||
| 5/5/2018 | C23456 | ABC1 | 5/2/2018 | Consider | 6 | |||
| 5/5/2018 | D12345 | ABC2 | 5/3/2018 | Compare Elsewhere | 7 | |||
| 5/5/2018 | D24567 | ABC3 | 5/4/2018 | Rejected | 8 |
Sheet 2
Each data point in all three columns
=IFERROR(INDEX('Sheet 1'!A:A,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"")
=IFERROR(INDEX('Sheet 1'!B:B,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"")
=IFERROR(INDEX('Sheet 1'!C:C,MATCH(ROWS($2:2),'Sheet 1'!$I:$I,0)),"")
| ABC | ||
| date | serial number | Company |
| 5/1/2018 | B12345 | ABC |
| 5/2/2018 | B23456 | ABC1 |
| 5/3/2018 | B34567 | ABC2 |
| 5/4/2018 | B45678 | ABC3 |
| 5/5/2018 | C12345 | ABC |
| 5/5/2018 | C23456 | ABC1 |
| 5/5/2018 | D12345 | ABC2 |
| 5/5/2018 | D24567 | ABC3 |
Thank you in advance.
Josie
- Hello, I'm needing assistance in doing a similar formula as the others on this. I'm using an excel work book, Sheet named FW.Model column AA5 and AB5, I need to look up on the Sheet named Page 1, Columns B1:C357, if match return value in column E (from same tab - Page 1) 5th column over.
Basically if the manufacture and model match the manufacture model on the second tab, return a value in the 5th column on the second tab.
Thank you in advance for your help.
