Hi,
try

=sumproduct(--(a1=sheet2!$X$1:$X$1000),sheet2!$XY$1:$XY$1000)


"sierralightfoot" wrote:

in excel
sheet 1, column 1 contains values i want to use to lookup/match,vlookup the
values in sheet 2 columnx, when matched, I want to return values in sheet 2
column xy, [and maybe column xyy and xyyy too].