• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Step 1 – Register, Activate Your Account and Log In
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate
3. Login

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm that you’re a real person. ...
• ### Recent Forum Posts

#### Populate VLOOKUP formula using VBA for all rows that have data in column A

Hi and welcome
please wrap your code with code tags ( select the code and click the #button). it keeps the code structure ( see post #2 as an example)...

Pecoflyer Today, 09:58 AM

#### Thanks for your reply

Please also see my previous reply.

I played around with this a little more and I got the function to work properly. However, I noticed that...

bradgivens Today, 09:55 AM

#### Thanks for your reply

I made the suggested correction, however, when I run the code in the sample workbook that I will attach here, they all end up saying "Duke"....

bradgivens Today, 12:44 AM

#### Formula for variable transformation

Hello - I'm sorry that my suggestion didn't resolve your issue. I don't think that I fully understand what your trying to do, as the formulas you have...

Hercules1946 Yesterday, 11:40 PM

#### Populate VLOOKUP formula using VBA for all rows that have data in column A

Make this change

Code:
`If Cl.Offset(, 6).Value = "Item" Then Cl.Offset(, 6).Value = .Item(Cl.Value)`
...

Fluff Yesterday, 05:45 PM