vlookup?

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

sierralightfoot

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Vlookup & relative cell reference? 2
Need VLOOKUP to Work Two Ways 0
First column of range in VLOOKUP contains formula 2
VLOOKUP Function to return values in multipal Columns 6
Sum Values from different column 1
Complex matching with ranges 1
lookups 4

Top