V Lookup assistance Needed

**jdk789** · 09-03-2012, 08:46 AM

Hi Guys.

I have a spreadsheet which is going to hold orders each day and each tab is going to be a month. I have the September tab working however I am struggling to get the October and November tab Working.

What I will need as a finished product is a tab for each month from September 2012 to September 2013 each with V Lookup to pull orders to the main sheet.
I think the V Lookup part is correct however the drop down box that should contain the order number isn't working properly.

I have attached the spreadsheet. Any help would be much appreciated as I am very stuck.

**dilipandey** · 09-03-2012, 09:09 AM

Hi jdk,

I found issues with defined names, now corrected.

Also, the formulas in last tab (nov month) has some reference back to oct month, now corrected. thanks.

See attached:- HBDI Prototype (DO NOT USE).xlsm

regards,
DILIPandey

<click on below 'star' if this helps>

**jdk789** · 09-03-2012, 09:14 AM

Hi Dilipandey.

Thank you for sorting that it was a great help. Could you explain to me how you got the correct order numbers to pull through please as this is the bit I do not understand and I will need to do this a lot in the future

Kind Regards
James King

**dilipandey** · 09-03-2012, 09:23 AM

correct order numbers to pull through

In defined name or in vlookup formula ?

Regards,
DILIPandey

<click on below 'star' if this helps>

**jdk789** · 09-03-2012, 09:46 AM

Sorry for the confusion. The part I do not understand is the drop down box. How did you set the values in there. I have had a look and I can not find anywhere to set the values.

**dilipandey** · 09-05-2012, 04:47 AM

Okay..

Go to Sep 2012 sheet
select the drop down, press alt +D+L
In the settings tab, you will find formula as "=SepOrders"
"SepOrders" is a defined name which is used here as a data validation source list

Now how to see this defined name and where is this defined / what logics etc.. ??
press ctrl + F3
In the window, you'll find "SepOrders" listed there
select that and you'll find the following formula at the bottom in field "Refers to:" :-
='Sept 2012'!$A$2:$A$500

this is the range assigned to that name.

I hope this is clear now.. thanks.
feel free to reach back in case of any queries..

Regards,
DILIPandey

<click on below 'star' if this helps>