Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I'am a newbee in using vba/excel and got this problem.

Can anyone help ?

This is what I'm trying to do

Type a name in a cell"A2" in sheet1 , if name exist in sheet3 "An"

then

sheet1 "C2" is filled with value of "sheet3" "Cn"

If the name do not exist in sheet3 then I want to call a Macro to

put the name in sheet3 first.

( "A2" is filled with #N/A )

I've used this formula and it works but I do not know how to call a

macro.

=IF(ISNA(VLOOKUP(Name;"sheet3";6;FALSE));"not-present";VLOOKUP

(Name;"Sheet3";6;FALSE))

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

Related Topics:

- Formula using range name in VBA code
- Getting a formula to copy from inside VBA
- VBA code to add values in two cells which have formulas
- VBA or array formula?
- formula help but not vba please
- Copy down formula with vba
- cells containing formula that refer to user-defined VBA function
- VBA Code for pasting a set of formulas down a data range
- VBA variable range in a formula
- Convert code from excel 2000 vba to excel 2003 vba
- writing vba code to generate vba code
- Cannot use the VBA add table command of MS word in MS Excel VBA
- writing vba code to generate vba code
- Cannot use the VBA add table command of MS word in MS Excel VBA
- Placing VBA Code "Live" Into Another WkBook Via VBA
- Probs with datareader and Validator
- user control prob
- jboss install prob
- simple datatype prob...
- can anybody help in Flickering prob in Applet
- GUI PROB
- Prob. in mail enabling in JAVA
- DB Internationalization prob
- help me in j2ee prob
- prob in using SQL Server through JDBC