How to use Formula: = IFERROR
Requirement: To compare 2 columns and if the value in column A matches a value in column C then move the corresponding value in column B to column D
If value in Column A1 matches value in column C2 move the value in column B1 to column D2
| AAAA | Closed | EEEE | |
| BBBB | Open | AAAA | Closed |
| CCCC | Closed | GGGG | |
| DDDD | Open | CCCC |
Closed
|
Solution: =IFERROR(INDEX($B$1:$B$4,MATCH(C1,$A$1:$A$4,0)),"")
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use SUMIFS and include 'All' to Drop-down IndexMatch |
| How to Compute a Date Difference in an IF statement |
| How to use the DATEDIFF Function (VBA) |
| How to COUNTIF using input cell as range depth |
| How to combine more that one IF AND formula |
| How to use IF formula with multiple criteria |
| How to use SUMIF |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
