searchingforhelp
Board Regular
- Joined
- Nov 11, 2020
- Messages
- 67
- Office Version
- 365
- Platform
- Windows
Hi, I have created a formula in Sheet1 to find the EEE number in sheet2 column B. Unfortunately, I continue to receive a NA which should not be the case as the EEE number does exist. I do not need to add an IFERROR to the formula as all the EEE numbers are present.
Sheet1
Sheet2
Any help you provide will be greatly appreciated.
Thank you.
Sheet1
Mr Excel - Copy.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Column | Dates | Results | ||
2 | TYU-004321 | 1/14/2022 | #N/A | ||
3 | TYU-007000 | 1/5/2022 | |||
4 | TYU-005656 | 1/10/2022 | |||
5 | TYU-003333 | 2/5/2022 | |||
6 | TYU-007330 | 3/6/2022 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | C2 | =VLOOKUP(A2&"-"&B2,Sheet2!$A$2:$C$6000,2,FALSE) |
Sheet2
Mr Excel - Copy.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Column | Number | Dates | ||
2 | TYU-005656 | EEE-005555 | 1/10/2022 | ||
3 | TYU-007330 | EEE-007321 | 3/6/2022 | ||
4 | TYU-003333 | EEE-004372 | 2/5/2022 | ||
5 | TYU-007000 | EEE-005558 | 1/5/2022 | ||
6 | TYU-004321 | EEE-004444 | 1/14/2022 | ||
Sheet2 |
Any help you provide will be greatly appreciated.
Thank you.