Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

VBA Formula prob

  Asked By: Alex    Date: Feb 18    Category: MS Office    Views: 1282
  

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))

Share: 

 

No Answers Found. Be the First, To Post Answer.

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




Tagged: