Vlookup help with function

D

ddjlddjl

I need to perform the following lookup and comparison: On sheet 1, if content
in a1:a700 AND content of b1:b700 AND content of c1:b700 matches exactly to
Sheet 2, content in a1:a700 AND content of b1:b700 AND content of c1:b700,
then return value in d1:d700 from sheet 2, if no match, return 0 (zero).
 
M

Max

I'm presuming you had a typo for: c1:b700
ie its meant as: c1:c700

In Sheet1,
Put in D1, normal ENTER:
=IF(ISNA(MATCH(1,INDEX((Sheet2!$A$1:$A$700=A1)*(Sheet2!$B$1:$B$700=B1)*(Sheet2!$C$1:$C$700=C1),),0)),0,INDEX(Sheet2!$D$1:$D$700,MATCH(1,INDEX((Sheet2!$A$1:$A$700=A1)*(Sheet2!$B$1:$B$700=B1)*(Sheet2!$C$1:$C$700=C1),),0)))
Copy D1 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
 

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

compare three cells 1
Need Help 4
setting cell values based on a 3rd cell 4
Copying a cell value to another sheet by using If statement 1
Getting a value from large table. 5
Excel functions 0
Referencing several cells with IF? 2
I need to do a calculation based on the values in two cells 2

Top