Return a symbol where 2 columns match

Bravo33

Board Regular
Joined
Jan 10, 2008
Messages
73
I have 2 worksheets.
Sheet 1 has different data in column A and Column B
Sheet 2 has the same data from column A:A but not in the same order and Sheet 1 Column B data is transposed to row from B1
I want to place a symbol (Wingdings 3 "p" which is a triangle) at the intersection on sheet 2 by where Sheet 1 criteria are met.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,055
Office Version
365
Platform
Windows
Something like:

=IF(COUNTIFS(Sheet1!$A:$A,$A2,Sheet1!$B:$B,Sheet2!B$1),"p","")

Format the cells how you want.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,683
Messages
5,445,941
Members
405,370
Latest member
Theglyde

This Week's Hot Topics

Top