Forum Discussion

lamid77's avatar
lamid77
Copper Contributor
May 08, 2024

Hepl with columes compering

Hi, I need to compeer 2 columns and get proper text from third column?!

If text in the cells of those two columns is equal them copy/past text from third column 

 

 

 

  • lamid77 

     

    Try this:

    =IFERROR(INDEX($A$1:$B$50,MATCH(C1,$A$1:$A$50,0),2),"")

     

    Adjust the ranges accordingly. A1:A50 would be the range on your right containing A####, B1:B50 is the range containing the information to be returned which is on your right. C1 would be the reference to the cell on your left, which is also A####. Then drag down to fill. 

Resources