Use Loop to find an Empty cell then use condition

[fluffyvampirekitten]

I want to create a macro that can help me find for an empty cell and then use some conditions

'Find the cell that is empty.a
If cell is empty , call the vlookup function method else display "Not indicated"

how do i do it ?
Thanks and appreciated your help .
-NewUserinMacro

 

[farmerscott]

F.V.K,

Welcome to the forum.

You need to give us some more information on your problem.

1. The empty cell you are looking for is in which sheet?? sheet name?

2. the empty cell is the last, in which column ?? or the last in the used area?

3. Is the empty cell 'truely' empty or just looks empty from the result of a formula?

4. Are you looking for the first empty cell in any column?

5. Do you want VBA to do the VLOOKUP for put the formula in the cell?

6. Where is the lookup value situated? Sheet name and Range?

7. Where is the table to be looked up? Sheet name and Range?

8. What column is the value in?

9. Do you want an exact match?

10. What happens when a match is not found? "Not indicated" is placed in the cell?

thanks

FarmerScott