| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Vlookup
Hi,
I need some help in modifying a vlookup formula the following code works however I need to modify it so that when the cell in "Like Store" (B2) is blank the code will place the cell value of Rounded of "3886" in place of the #N/A. VLOOKUP(B2,A$2:C655,3,FALSE) This is in the column for "Final Weighting" Store Like Store Weighting Weighting % Reduction Weighting - % Rounded Final Weighting 1001 1006 39142 10 35227.8 35228 39414 1002 1001 36606 10 32945.4 32946 39142 1003 38858 90 3885.8 3886 #N/A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify a vLookup? | Excel Worksheet Functions | |||
| Modify a UDF please? | Excel Worksheet Functions | |||
| Vlookup - modify dropdown lists | Excel Worksheet Functions | |||
| modify vlookup | New Users to Excel | |||
| Modify this a bit | Excel Programming | |||
Threaded Mode
