| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookups in Excel 2003
I am trying to copy a vLookup that I created in one spreadsheet into another
so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
Maybe we could see this formula
"Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
=VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045)
I am trying to find a reference number in the 4th column (D) for an item number which is in the 2nd column. I've entered the number into the G2 location, and I know the number is in the 2nd column....but it is not working. There are values listed up to row 2045. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
=VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045)
I am trying to find a reference number in the 4th column (D) that belongs to an item number that I am entering into the lookup cell (G2)...I know the item number is in the column that contains all the item numbers. There are entries up to row 2045, and there are 4 columns. Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
=VLOOKUP(value,table,column,FALSE/TRUE)
value is the value you are looking up, G2 Table is the data table you are looking at, of which the first column MUST be where your value(s) will be. column is the column number as determined by your table, that you need FALSE=exact match and TRUE= near match(and table must be sorted). so =VLOOKUP(G2,$B$1:$E$2045,3,FALSE) HTH. -- John C "Richard Champlin" wrote: =VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045) I am trying to find a reference number in the 4th column (D) for an item number which is in the 2nd column. I've entered the number into the G2 location, and I know the number is in the 2nd column....but it is not working. There are values listed up to row 2045. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
I have tried that, and still am not getting a value returned. The value
being looked up is in the 1st column. I can't for the life of me figure out what is wrong...and it's probably very simple and right in front of me. What if I e-mail a file? -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "John C" wrote: =VLOOKUP(value,table,column,FALSE/TRUE) value is the value you are looking up, G2 Table is the data table you are looking at, of which the first column MUST be where your value(s) will be. column is the column number as determined by your table, that you need FALSE=exact match and TRUE= near match(and table must be sorted). so =VLOOKUP(G2,$B$1:$E$2045,3,FALSE) HTH. -- John C "Richard Champlin" wrote: =VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045) I am trying to find a reference number in the 4th column (D) for an item number which is in the 2nd column. I've entered the number into the G2 location, and I know the number is in the 2nd column....but it is not working. There are values listed up to row 2045. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
My bet is that there is a difference between the value that you're looking up
and the value that looks like a match in the first column of the lookup range. It could be an extra space (leading/trailing/embedded???) Or (my bet!) that one value is a value that looks like a number, but is really text--and the other value is really a number. Debra Dalgleish has lots of notes he http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://contextures.com/xlFunctions02.html#Trouble Richard Champlin wrote: I have tried that, and still am not getting a value returned. The value being looked up is in the 1st column. I can't for the life of me figure out what is wrong...and it's probably very simple and right in front of me. What if I e-mail a file? -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "John C" wrote: =VLOOKUP(value,table,column,FALSE/TRUE) value is the value you are looking up, G2 Table is the data table you are looking at, of which the first column MUST be where your value(s) will be. column is the column number as determined by your table, that you need FALSE=exact match and TRUE= near match(and table must be sorted). so =VLOOKUP(G2,$B$1:$E$2045,3,FALSE) HTH. -- John C "Richard Champlin" wrote: =VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045) I am trying to find a reference number in the 4th column (D) for an item number which is in the 2nd column. I've entered the number into the G2 location, and I know the number is in the 2nd column....but it is not working. There are values listed up to row 2045. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookups in Excel 2003
Thanks Dave,
The info from Debra Dalgleish was the trick...I was in the ballpark, but had neglected to check if the reference column in which I was searching for numbers was text vs. number. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Dave Peterson" wrote: My bet is that there is a difference between the value that you're looking up and the value that looks like a match in the first column of the lookup range. It could be an extra space (leading/trailing/embedded???) Or (my bet!) that one value is a value that looks like a number, but is really text--and the other value is really a number. Debra Dalgleish has lots of notes he http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://contextures.com/xlFunctions02.html#Trouble Richard Champlin wrote: I have tried that, and still am not getting a value returned. The value being looked up is in the 1st column. I can't for the life of me figure out what is wrong...and it's probably very simple and right in front of me. What if I e-mail a file? -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "John C" wrote: =VLOOKUP(value,table,column,FALSE/TRUE) value is the value you are looking up, G2 Table is the data table you are looking at, of which the first column MUST be where your value(s) will be. column is the column number as determined by your table, that you need FALSE=exact match and TRUE= near match(and table must be sorted). so =VLOOKUP(G2,$B$1:$E$2045,3,FALSE) HTH. -- John C "Richard Champlin" wrote: =VLOOKUP(G2,$A$1:$E$2045,4,$B$1:$B$2045) I am trying to find a reference number in the 4th column (D) for an item number which is in the 2nd column. I've entered the number into the G2 location, and I know the number is in the 2nd column....but it is not working. There are values listed up to row 2045. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle "Mike H" wrote: Maybe we could see this formula "Richard Champlin" wrote: I am trying to copy a vLookup that I created in one spreadsheet into another so that I can simply tailor it to the new spreadsheet. No matter what I try, it does not return anything other than "#VALUE!" I think I am unclear as to the parameters. -- Richard Champlin Administrative Program Assistant II Children''''''''s Hospital & Regional Medical Center, Seattle -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Calculation' showing on my excel spreadsheet (VLookups don;t work | Excel Discussion (Misc queries) | |||
| Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
| VLOOKUPS | Excel Worksheet Functions | |||
| vlookups | Excel Discussion (Misc queries) | |||
| vlookups | Excel Worksheet Functions | |||
Linear Mode
