Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup problems
I am trying to use lookup using a vector and array. My lookup is in column
A500 thru A550. I need to locate the information in Column D1 thru D800 and return the result from Column F1 thru F800. If nothing is found I need it to return the result of 0. I havetried many times with no results. What to do now. Rose |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup problems
Hi!
So you're looking for an exact match? Try this: =IF(COUNTIF(D$1:D$800,A500),VLOOKUP(A500,D$1:F$800 ,3,0),0) Biff "Rose Davis" wrote in message ... I am trying to use lookup using a vector and array. My lookup is in column A500 thru A550. I need to locate the information in Column D1 thru D800 and return the result from Column F1 thru F800. If nothing is found I need it to return the result of 0. I havetried many times with no results. What to do now. Rose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Lookup problems | Excel Worksheet Functions | |||
Lookup problems | Excel Worksheet Functions | |||
Lookup Function Problems | Excel Worksheet Functions | |||
How to overcome LOOKUP function problems? | Excel Worksheet Functions | |||
lookup problems | New Users to Excel |