Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Lookup, Match or a combination of all
Hi
I have 1 excel spreadsheet with several worksheets. What I need to do is to take the value from 1 cell in one sheet look at a list of values on a second sheet and return the value but only if there is an exact match else I need it to return a 0. At the moment with Lookup it is returning a value that is the closest match. Sheet 1 Column A Column B Column C Column D Column J sumtotal name title Code Value of Col B from sheet 2 Sheet 2 Column A Column B Code Value I need it to look the value from column D in Sheet 1 and match it to the Code in Column A on sheet 2 and return the value of Column B to Col J in sheet 1 else return a 0 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination...SumProduct, Index, Match? | Excel Worksheet Functions | |||
Lookup valid combination of multiple cells | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup or Match ? | Excel Worksheet Functions | |||
combination of vlookup and match question | Excel Worksheet Functions |