View Single Post
  #5   Report Post  
Old January 1st 21, 10:04 AM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,832
Default Compare two Columns , and if is it a Match , copy

Hi,

Am Thu, 31 Dec 2020 12:48:19 -0800 (PST) schrieb Xxer Xxes:

For now , I get a #NAME? result , but I'll try to work with
this function untill i'll get the wright results. In excel 2012 I haven't
this function : ,, IFERROR ,, , I only have in my list of functions a function
,,ISERROR ,, .


try in BW1:
=IF(ISNA(MATCH($BT1,$BD$11:$BD$42000,0)),"",INDEX( $BK$11:$BM$42000,MATCH($BT1,$BD$11:$BD$42000,0),CO LUMN(A1)))
and copy the formula to BY1 and then down.


Regards
Claus B.
--
Windows10
Office 2016