98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Match Formula Check
Match Formula Check
Resolved · High Priority · Version 365
Wed 30 Oct 2024, 10:38Delegate Kay Khan said...
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
Wed 30 Oct 2024, 12:18Trainer Jens said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
