QUESTION: Looking up value

jsiason

Board Regular
Joined
Nov 9, 2005
Messages
72
Hi. i hope you can help me on this:

column A is filled up from rows 1 to 1000.
column B is filled up from rows 1 to 20.

what function to use to check if any in column B is listed in column A?
Such that if there's a match, it will indicate so (in whatever way).

thanks.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
You could use conditional formatting...

Select B1:B20 with B1 active cell

Format > Conditional Formatting > "Formula is"

=MATCH(B1,A$1:A$1000,0)

select a format e.g. red pattern
 

Watch MrExcel Video

Forum statistics

Threads
1,118,911
Messages
5,575,001
Members
412,633
Latest member
simon_elvin
Top