Kay Khan has attended:
Excel Advanced - For Power Users course
Excel Advanced - Formulas & Functions course
Match Formula Check
Hi Team,
Just after some guidance please in ref to Match formula.
I have one value in column B
The same value is also present in column O.
I have tried to use the formula below to match that both values are the same however seems there is an error in my formula.
=IF(B2=O2,”Match”,” ”)
Please could you provide any pointers on this.
Thanks
RE: Match Formula Check
Hi Kay,
Thank you for the forum question.
Try
=IF(B2=O2,"Match","")
You will have to use speech marks (Shift 2)
The formula looks
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
