vlookup?

  • Thread starter Thread starter sierralightfoot
  • Start date Start date
S

sierralightfoot

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].
 
I can't get this to workIs there a function I can use?

Eduardo said:
Hi,
try

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


sierralightfoot said:
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].
Click to expand...
Click to expand...
 
Back
Top