Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

is it possible to combine the following together

in colum "B" =vlookup(A2,$J$2:$M$2000,False,2)

and

in colum "D" =if(iserror(B2),"A",B2)

if as some times happens colum "B" gives readings as " #N/A "

is it possible to combine the two functions so that only one colum is

required instead of the two i am using at present.

Didn't find what you were looking for?
Find more on combining formula
Or get search suggestion and latest updates.

Related Topics:

- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- How to add several conditions for formula "SUMIF"
- formula help but not vba please
- Formula multiplying ActiveCell with "F11"
- copy down formulas in excel
- Automatically apply specific formulas to specific columns
- Romberg's intigration formula.
- Loop in formula
- Copy down formula with vba
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings
- Copy Value produced by formula in cell C3 to cell D3
- Can Any one help me writing logic for the given formula
- 2003 - Moving to a formula address
- formula
- Any idea how to write formula?
- Formula with conditional text