VLookUp issue

**lionlunatication** · 01-14-2013, 02:08 PM

Hi all,

Here's the story. I have a table whose first column's got all the dates of the year (all 365 of them) and a second column that has an integer number (assigned to each date). I am trying to use the VLookUp function in VBA to search today's date within the first column, and return its corresponding integer value. Well, today's not my day.

I want to use this value to refer to a column in another worksheet (in this sheet, the columns are labelled across by these integer values).

My Lookup function just won't work. Anyone bold enough to tackle this problem?

Thanks a bunch.
lunaticlion

**TMS** · 01-14-2013, 02:14 PM

That shouldn't be difficult. We can't really tell you what might be wrong with your formula without seeing it, and, if the formul looks OK, we'd need to see the data.

So, best bet, upload a sample workbook.

Regards, TMS

**lionlunatication** · 01-14-2013, 04:26 PM

Hi TMS,

I've uploaded a mock workbook. Kindly take a look. I'm sure it's the way I'm calling the function that's causing the issue.

**skonduru** · 01-14-2013, 05:02 PM

Hey,

This thread might be helpful.

http://www.excelforum.com/excel-prog...or-1004-a.html

**WHER** · 01-14-2013, 05:32 PM

In your macro "BossScript" i inserted the following (red) line of code to check the value of variable "deliverDate"

Please Login or Register  to view this content.

In the Immediate window, the result was:

Please Login or Register  to view this content.

Maybe not what you expected?

**lionlunatication** · 01-15-2013, 09:32 AM

WHER,

You're right, not what I expected at all. I was trying to assign each value contained in the column of D5 (in sheet "Main") to "deliverDate" one by one. The code was my attempt to select a dynamic range, and probably goofed. Any tips?

LL

**lionlunatication** · 01-20-2013, 07:15 PM

I got the VLookup function to work in one module, but doesn't work in another module of the same workbook :S

This works:

Please Login or Register  to view this content.

But this doesn't:

Please Login or Register  to view this content.

Help, please!

**lionlunatication** · 01-20-2013, 08:57 PM

Nvm, solved it! Just conflicting conditional statements...

**TMS** · 01-20-2013, 09:33 PM

Thanks for letting us know. Glad you have a solution.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.