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?
- formula help but not vba please
- How to add several conditions for formula "SUMIF"
- VBA code to add values in two cells which have formulas
- VBA or array formula?
- Paste Formula help
- R1C1 Formula
- Three Leveled Formula
- Formula using range name in VBA code
- searching within formulas
- Populate Formula(Function) in rows
- Getting a formula to copy from inside VBA
- VBA Formula prob
- Blank Formula bar
- Manually creating a row outline with no formula anywhere
- sum formula
- cells containing formula that refer to user-defined VBA function
- Named formula/Windows dialog boxes
- Stuck on copying formula from 1 sheet to another
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Array Formula
- Copy down formula with vba
- Loop in formula
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings