- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel VLOOKUP question?
Posted on 5/29/14 at 3:11 pm
Posted on 5/29/14 at 3:11 pm
Can I have the sheet that VLOOKUP table_array is on change dynamically based on another cell?
For example the formula would be:
=VLOOKUP(AN5,C3!$B1$E$10000,4,FALSE)
Telling it to look for the value in AN5 in the sheet named "whatever cell value" of C3 is, then over 4 for result.
Any help is appreciated, or if there is a better formula please share.
Background:
Bascially, I'm trying to use VLOOKUP to pull results from different sheets based on what data I want to see. So I have raw sales data for each month on respective sheets. I want to be able to type the month i want to see (01/10) for example into a cell, that then tells it to pull data from that sheet.
For example the formula would be:
=VLOOKUP(AN5,C3!$B1$E$10000,4,FALSE)
Telling it to look for the value in AN5 in the sheet named "whatever cell value" of C3 is, then over 4 for result.
Any help is appreciated, or if there is a better formula please share.
Background:
Bascially, I'm trying to use VLOOKUP to pull results from different sheets based on what data I want to see. So I have raw sales data for each month on respective sheets. I want to be able to type the month i want to see (01/10) for example into a cell, that then tells it to pull data from that sheet.
3
Posted on 5/29/14 at 3:55 pm to lsu02150
=IF(L4=0,0,VLOOKUP($L$4,U1:V74,2,FALSE))
Are you talking about something like that?
Are you talking about something like that?
Posted on 5/29/14 at 4:27 pm to lsu02150
Excel is magical, if you can think of something logically that can could be done in a spreadsheet, excel is 99.9% of the time able to do it.
Posted on 5/29/14 at 4:31 pm to lsu02150
I just finished doing this. You may need to use the INDIRECT inside your VLOOOKUP. It would be something like this:
=VLOOKUP(AN5,INDIRECT(C3&"!$B1$E$10000"),4,FALSE)
ETA a missing )
=VLOOKUP(AN5,INDIRECT(C3&"!$B1$E$10000"),4,FALSE)
ETA a missing )
This post was edited on 5/29/14 at 6:01 pm
Posted on 5/29/14 at 5:11 pm to CubsFanBudMan
This did it. Thanks!
Posted on 5/29/14 at 5:55 pm to lsu02150
Quality thread. Quality responses! 
Posted on 5/30/14 at 12:00 am to HubbaBubba
When you start nesting INDIRECT, INDEX, SUMIFS, MATCH, &, etc into Excel formulas, you are starting to separate the men from the boys.
I love this stuff
I love this stuff
Posted on 5/30/14 at 5:39 am to lynxcat
What website do you guys use as an excel reference?
I am trying to create a formula that allows me to measure in units of time. IE:
In 4 cells, I would have 18:00, 19:00, 20:00, 21:00
I enter -:45 into a cell.
Then the cells change into 17:15, 18:15, 19:15, 21:15
I am trying to create a formula that allows me to measure in units of time. IE:
In 4 cells, I would have 18:00, 19:00, 20:00, 21:00
I enter -:45 into a cell.
Then the cells change into 17:15, 18:15, 19:15, 21:15
This post was edited on 5/30/14 at 5:40 am
Posted on 5/30/14 at 9:10 am to Azazello
quote:
What website do you guys use as an excel reference?
I usually do a google search and look for results from www.mrexcel.com.
Posted on 5/30/14 at 1:17 pm to CubsFanBudMan
MrExcel - technical question.
Chandoo - envision what something could possibly look like
YouTube - practical How Tos
Chandoo - envision what something could possibly look like
YouTube - practical How Tos
This post was edited on 5/30/14 at 1:18 pm
Posted on 5/30/14 at 3:24 pm to GenesChin
I tried to do a vlookup for data after a symbol ^ and I couldn't get it to work.
Data like blah34098^8F515647
I just wanted the second part from a different table.
I tried for about a whole day and it never worked.
Data like blah34098^8F515647
I just wanted the second part from a different table.
I tried for about a whole day and it never worked.
Posted on 5/30/14 at 8:45 pm to MagicCityBlazer
use text to columns to break out data before and after ^ into two columns and then run your lookup on the clean data in new column.
Posted on 5/30/14 at 9:10 pm to lynxcat
I forgot all that stuff in college. Would be useful now 
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News