If and Countif

[losty]

Hey guys,

If I have 2 columns in a table such as below and I want to query one of them to find out if a particular number is present I've figured out how to use IF/COUNTIF to do this. However, what I can't do is then get it to paste the corresponding value to the number (in the example below it'd be c).

Any ideas if I can do this with formulas?

Thanks!

=IF(COUNTIF(A1:A12,"3"),"???","MISSING")

ColumnA ColumnB
1 a
2 b
3 c
4 d
5 e
6 f
7 g
8 h
9 i
10 j
11 k
12 l

[Tony Valko]

Here's my best guess at what you're wanting to do...

Data Range

	A	B	C	D	E
1	Header	Header	------	Header	Header
2	1	a		3	c
3	2	b
4	3	c
5	4	d
6	5	e
7	6	f
8	7	g
9	8	h
10	9	i
11	10	j
12	11	k
13	12	l

This formula entered in E2:

=IFERROR(VLOOKUP(D2,A2:B13,2,0),"Missing")

[losty]

Perfect, just what I was after.

[Tony Valko]

You're welcome. Thanks for the feedback!