ExcelBanter - vlookup?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup? (https://www.excelbanter.com/excel-worksheet-functions/237940-vlookup.html)

sierralightfoot

vlookup?

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].

Eduardo

vlookup?

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].

sierralightfoot

vlookup?

I can't get this to workIs there a function I can use?

"Eduardo" wrote:

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].

All times are GMT +1. The time now is 02:20 AM.