IF function question

**blue_izce8** · 05-08-2013, 06:24 AM

Hi all I would like to ask how I will use this function with the example below:

If a1 is not equivalent to TRANSFER then N/A must auto-populate a3. But if a1 is TRANSFER then a3 should have a dropdown list.
Thanks in advance.

**dilipandey** · 05-08-2013, 06:48 AM

Hi blue_izce8,

Is it possible that you can have N/A in the dropdown list along with other elements in A3 ?

Regards,
DILIPandey
<click on below * if this helps>

**blue_izce8** · 05-08-2013, 07:42 AM

we are actually thinking of saving time that is why we wanted to make the N/A appear without being chosen

**dilipandey** · 05-08-2013, 07:44 AM

Okay.. then only solution, as per me, is VBA (macros)... if you are fine with this, upload a sample workbook having your test data. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**blue_izce8** · 05-08-2013, 07:51 AM

I don't have the file available right now

is it possible for you to teach me what do once you give me the VBA?

**dilipandey** · 05-08-2013, 07:52 AM

You need to include that VBA (Module) in your file .. thats it.

but I doubt if you stuck, it will invite re-work for both of us.. hence asking you to upload a sample file. thanks.

Regards,
DILIPandey
<click on below * if this helps>