We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Write number to cell if same number exist in diffrent cell [closed]

asked 2018-05-19 17:08:38 +0200

unknown1001 gravatar image


How to create in cell formula to show in that cell number 1 when formula is correct. Formula will be to check if the number match number from diffrent cell.

Best regards

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-09 21:50:42.419118


This question is not precise or clear enough to answer. Please edit the question to give a complete example and the desired result. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-05-19 17:49:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-20 08:31:33 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

=IF(D1; A1;"") (OR depending on language: =IF(D1, A1,"") ) This will check if the cell D1 contains a TRUE value and will return A1 otherwise will return an empty string. D1 contain the formula that will check and return TRUE or FALSE.

Going further =IF(ISERROR(D1); A1;"") (or any other checking function as: ISNA, ISERR ...)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-05-19 17:08:38 +0200

Seen: 103 times

Last updated: May 20 '18