Microsoft Office Forums - View Single Post - If or formula help

Thread: If or formula help

View Single Post

Old

04-24-2018, 01:08 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

You can create a table of values to look for off to the side then reference that list..

e.g

=IF(Isnumber(Match(A2,$Y$2:$Y$10,0)),"NSA","")

copied down

where Y2:Y10 contains the list of values to find in column A

Reply With Quote