danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
[/FONT]
A3:B13 is Table1
Column A is made up of either text or numbers.
Column B is only text format.
How could I go about finding a solution to Output A or Output B (whichever is easier)
Output A would deliver YES if there is a corresponding value in Column B for an invoice number in Column A
Output B would just deliver the document number.
(I paste the data in Table1 so that my formulas are dynamic and I don't have to keep updating the row ranges.
Hoping I could the same thing here)
[/FONT]
Book1 | ||||
---|---|---|---|---|
A | B | |||
3 | Invoice Number | Document Number | ||
4 | M10001 | 5100000000 | ||
5 | M10001 | |||
6 | 22 | 5100000222 | ||
7 | 22 | |||
8 | ||||
9 | ||||
10 | OUTPUT A) | |||
11 | Invoice Number | Document Number | ||
12 | M10001 | Yes | ||
13 | 22 | Yes | ||
14 | ||||
15 | OUTPUT B) | |||
16 | Invoice Number | Document Number | ||
17 | M10001 | 5100000000 | ||
18 | 22 | 5100000222 | ||
Sheet1 |
A3:B13 is Table1
Column A is made up of either text or numbers.
Column B is only text format.
How could I go about finding a solution to Output A or Output B (whichever is easier)
Output A would deliver YES if there is a corresponding value in Column B for an invoice number in Column A
Output B would just deliver the document number.
(I paste the data in Table1 so that my formulas are dynamic and I don't have to keep updating the row ranges.
Hoping I could the same thing here)
[/FONT]