Vlookup in Tabs

[tim browne]

Hello,

I am trying to make a VLookup in A file which has tabs per month with the year added to it.
ON the front page I want to make the user enter the Month + Year of which they want the data to display and based on that the Vlookup for the data should appear correctly automatically. Somehow it seems Excel is not recognizing my formula to create the Tab Name as being a Tab name within the VLookup. Anyone knows how to solve my problem?

Data to fill in is in cells Row B.
I created a formula to make teh "Tab Name" IN cell F13: =("'"&B3&" "&B4&"'"&"!"&"F1:AJ36")
V Lookup Looks Like: =VLOOKUP(J2;F13:AJ36;5;FALSE)

Sheet attached. Thank you for the help!

[Jdevil]

=vlookup(j2;indirect(f13);5;false)

[MarvinP]

Hi Tim,

See if this does it for you
=VLOOKUP(J2,INDIRECT($F$13),5,FALSE)
in the attached.
Vlookup Indirect other Sheet.xls

[tim browne]

Wow you guys are fast! And indeed it works!
Now I am for the next dilemma and really notice how little I know...

I have received a data set for which unfortunately enough the dates are not in the first column but always one line above the data in the second column... Now I want a formula to put the date in front automatically, problem is that not every date contains the same amount of data rows so the formula should recognize to add a new date the moment an empty line is found.
I have attached what I mean.

Technically my formulla would look like the following, I just do not seem so be chosing the right formula's:

Below written in Cell A5
=IF(H5=BLANC)show B4, If H5 is any other value use A4 (cell above)... The only problem for me is that I am not sure the formula will recognise that the number of data before row H has a Blanc cell can be 3 of 10...

=IF((ISBLANK(H5); B4; A4))) does not work...

Thanks for the help.

Tim

[JohnTopley]

Try in A5 and copy down

=IF(ISNUMBER(LEFT(B4)+0),B4,"")

[tim browne]

Get an error on that one, sorry.

[JeteMc]

Try this in A5 and down:

Please Login or Register  to view this content.

Also format column A: Custom> m-d-yyy

[tim browne]

Amazing, that works perfectly! Thank you

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to select Thread Tools from the menu link above and mark this thread as SOLVED. I hope that you have a blessed day.

[JohnTopley]

See the attached.

[tim browne]

Yeah I made a stupid mistake... Needed to ; as got the ofrmula copied with , instead