| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup help with function
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). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup help with function
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)*(Sh eet2!$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 --- "ddjlddjl" wrote: 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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedded If Function in a Vlookup Function | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Linear Mode
