| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and VLOOKUP - how efficient?
IsNumber/Match is faster than CountIf though.
T. Valko wrote: Another way: Instead of duplicating the lookup and testing for an error, test to see if the value is present: =IF(COUNTIF(Data!A:A,A1),VLOOKUP(A1,Data!A:Z,26,0) ,"Inactive") Biff "anthonyg" wrote in message ... Hi I have a big dataset and each item needs to be classified as either "active" or "inactive". By default lines are inactive, unless they are contained within a subset that is listed in a separate database, where individual lines are classified active/inactive, in which case they are classifed the same as the separate database. I'm currently using the following formula in my classification column: IF(ISNA(VLOOKUP(A1,[Active Analysis]Data!A:Z,26,FALSE)),"Inactive",VLOOKUP(A1,[Active Analysis]Data!A:Z,26,FALSE)) My question is, when I use this formula does Excel execute the same lookup twice, or is it smart enough to do the lookup once and use the result twice? Either way it certainly seems to take a long time. Is there a more efficient method? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is more efficient | Excel Discussion (Misc queries) | |||
| more efficient way to lookup a range? | Excel Discussion (Misc queries) | |||
| something more efficient that =IF, and sytax questions | Excel Discussion (Misc queries) | |||
| how to plot efficient frontier | Excel Discussion (Misc queries) | |||
| is there a more efficient formula than... | Excel Worksheet Functions | |||
Threaded Mode
