Take the time to learn how to use the vlookup function. It will be your very best friend, trust me.
Any Excel experts? Need help.
- Thread starter Skooby
- Start date
Take the time to learn how to use the vlookup function. It will be your very best friend, trust me.
What's the syntax for your vlookup? If you're getting reference errors from vlookup, that means the cells you're looking for the value in have reference problems.
LOL...I never put excel on there. I'm no expert...I just know the basics.
I figured it out. I was referencing the wrong column (3 instead of 2). I also had to change the cells so they didn't view the numbers as text. (Data tab, Text to Columns, Finish).
iceberg_is_on_fire
Wearing Lions gear when it wasn't cool
HAHAHAHA!
I'm a pro at Excel but yeah, some people be faking the funk with this. I can do anything you want in Excel. My dashboards are piff.
I MIGHT NEED TO HIT YOU UP LATER. I HAVE AN IDEA FOR MY JOB BUT I JUST KNOW THE BASICS WITH EXCEL. I NEED HELP.
yeah breh, i don't fukk with excel even though I'm an IT manager lol.
when people ask me, I tell them to talk to Google cause I aint got it
Camile.Bidan
Banned
Three options.
1) cut the filtered columns then paste in blank workbook, the cut from new black workbook and paste to desired location.
2) vlookup or index, but it's unclear from your post that this is what you want.
3) if then function. =if(a1'tab1=a1"tab2",b1"tab1")
1) cut the filtered columns then paste in blank workbook, the cut from new black workbook and paste to desired location.
2) vlookup or index, but it's unclear from your post that this is what you want.
3) if then function. =if(a1'tab1=a1"tab2",b1"tab1")
Last edited:
Always practice safe sorting 
GollyImGully
Too many wavy women, gotta log outta IG
OP sitting at his desk like
OP sitting at his desk like
YOU LATE
I've been using arrays a lot more in Excel. Crazy how powerful this program can be 
Got one for you:
Instructions
1. Please add the custom data inputs (Disease based service line, In network physicians) into the Market Share Data tab
2. Create a graph showing in network market share by disease based service line
I'm unsure about sharing the file but here is a screenshot:
I placed this formula in "DiseaseBased" sheet:
=VLOOKUP($A2,$A$1:$C$3755,1,0)
And this in the "In Network" sheet:
=VLOOKUP($A2,A2:A1318,1,0)
I think the best way though is to copy and paste work from "DiseaseBased" & "In Network" sheets into "Custom" sheets, then using VLOOKUP to transfer it into "Market Share" [I think =VLOOKUP(Q2,'DiseaseBased'!,$A$1:$C$3755,1,0)] and =VLOOKUP(R2,'InNetwork'!A2:A1318,1,0)
Then add a Pivot table to get the values they are asking for before doing either a Circle graph or a bar graph
I'm unsure if this is the right way as I was stuck after copying the cells (the structure in order to make the graph)
Any help is appreciated
You ever try excel formula bot:Got one for you:
Instructions
1. Please add the custom data inputs (Disease based service line, In network physicians) into the Market Share Data tab
2. Create a graph showing in network market share by disease based service line
I'm unsure about sharing the file but here is a screenshot:
I placed this formula in "DiseaseBased" sheet:
=VLOOKUP($A2,$A$1:$C$3755,1,0)
And this in the "In Network" sheet:
=VLOOKUP($A2,A2:A1318,1,0)
I think the best way though is to copy and paste work from "DiseaseBased" & "In Network" sheets into "Custom" sheets, then using VLOOKUP to transfer it into "Market Share" [I think =VLOOKUP(Q2,'DiseaseBased'!,$A$1:$C$3755,1,0)] and =VLOOKUP(R2,'InNetwork'!A2:A1318,1,0)
Then add a Pivot table to get the values they are asking for before doing either a Circle graph or a bar graph
I'm unsure if this is the right way as I was stuck after copying the cells (the structure in order to make the graph)
Any help is appreciated
AI Data Analysis & Automation Tools - Formula Bot
AI data analysis, data prep and automation tools empowering users to work faster & smarter with data and spreadsheets.
formulabot.com
No sir. Asking here a I need to know if my process is correct.You ever try excel formula bot:
AI Data Analysis & Automation Tools - Formula Bot
AI data analysis, data prep and automation tools empowering users to work faster & smarter with data and spreadsheets.
I'm still stuck at the Pivot Table section ....