Lookup a value, if there is a corresponding text value, then...

[danhendo888]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

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

[/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]

 

[Special-K99]

Not much test data to go on.
Does the document number occur once only in column B for each occurrence of the invoice number? Based on your small amount of test data the answer is Yes.
So this works based on your test data.

in B17
=SUMIF(A$4:A$7,A17,B$4:B$7)
copy to B18

in B12
=IF(B17<>0,"Yes","No")
copy to B13

 

[danhendo888]

Thank you, that works perfectly for me.
I was looking for the: <>0 in your formula.