View Single Post
  #7   Report Post  
Old January 10th 21, 10:30 PM posted to microsoft.public.excel.programming
Xxer Xxes Xxer Xxes is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2020
Posts: 33
Default Compare two Columns , and if is it a Match , copy

Hi ,

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

for the formula above ,now I just have found it have
a miss in his task : formula, when find identical values ,
it bring the result from first number , repeting his values
from columns of BW to BY . If is not understable , I will
write here an exemple .