VLookup Code

[Gos-C]

Hi all,

I have two sheets - Log and Customer ID. Column F of Log has customer numbers and column G is blank; columns A and B of Customer ID have customer numbers and customer names but the customer numbers are formatted as text.

When I run the following code:

Please Login or Register  to view this content.

I get #N/A but when I convert the customer numbers on the sheet Customer ID to “numbers” the VLookup works. However, I still get #N/A for rows where the customer number on Log is blank.

Therefore, I would like to modify the code to (1) convert the customer numbers on the Customer ID sheet to "numbers" and (2) leave column G on the Log blank, if column F is blank.

Any help, please?

Thank you,
Gos-C

[Paul]

Hi Gos-C, try:

Please Login or Register  to view this content.

[moonsaga]

1. Highlight the Column and at the top in the tool bar the drop down in the number box under the home tab select number.
2. try this code

Please Login or Register  to view this content.

[Gos-C]

Paul, that works perfectly. Thank you! Thank you also, moonsaga.

Greatly appreciated,
Gos-C