| View previous topic :: View next topic |
| Author |
Message |
Moki
Joined: 23 Feb 2008
Posts: 85
Location: North Carolina
|
 Posted: Wed Apr 30, 2008 6:08 pm Post subject: OFF SUBJECT Excel Question CLOSED |
 |
|
You guys are the most helpfull community i've ever been involved with and figure who better to ask even though its not AHK related.
I am setting up a spreadsheet in excel at work and am having problems with a cells code can anybody let me know if they see a problem at first glance if not no big deal I will delete this topic if I don't get a reply after a little while.
| Code: | | =IF($E$77=612,VLOOKUP($F$77,INDIRECT("PartsList612"),18,FALSE),0) |
obviously you can't see what the code is refering to but the syntax is really what i need to know if its right thats all.
Thank you in advance 
_________________
Moki Mofiki
Last edited by Moki on Wed Apr 30, 2008 6:26 pm; edited 1 time in total |
|
| Back to top |
|
 |
SomeGuy
Joined: 21 Apr 2008
Posts: 92
Location: somewhere
|
| Posted: Wed Apr 30, 2008 6:11 pm Post subject: |
|
|
what is INDIRECT("PartsList612")
a function or something?
that parameter should be the range of cells to find the first parameter in......the 18 would be the value that is in the 18th column of the said range of cells..... |
|
| Back to top |
|
|
SomeGuy
Joined: 21 Apr 2008
Posts: 92
Location: somewhere
|
| Posted: Wed Apr 30, 2008 6:15 pm Post subject: |
|
|
this is directly from one of my spreadsheets.....
| Quote: | | =VLOOKUP(A94,'1-1-07'!A:A,1,FALSE) |
cell to be looked up, the sheet and range to look for it in, return the value in the first column, make sure it is exact match..... |
|
| Back to top |
|
|
Moki
Joined: 23 Feb 2008
Posts: 85
Location: North Carolina
|
| Posted: Wed Apr 30, 2008 6:25 pm Post subject: |
|
|
Thank you for your reply
INDIRECT function looks at the whole table for whatever you are trying to find.
(EXAMPLE: INDIRECT("tablename"),columnumberintable)
I figured it out .... the tab name was PartsList612 but the table wasn't named so I had to name the table PartsList612
_________________
Moki Mofiki |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
