| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
get the VLOOKUP function to return the "contents" of a cell?
=VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong?
Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
I suggest you change it to this:
=VLOOKUP(A1,Sheet2!A$1:C$216,2,1) entered in B1, then copy the formula down to row 730. I think you are getting "rows" and "columns" mixed up in your description. Hope this helps. Pete sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
Maybe
=vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
I tried both formulas and recieved the same answer then notices the numbers
in col.A are not alligned the same as the numbers in col.A on the table sheet! Feeling retarded HELP "Dave Peterson" wrote: Maybe =vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
=VLOOKUP(B1,Sheet2!$A$1:$C$216,2,1)
Copy down column B to B730 NOTE: B is a column, not a row Gord Dibben MS Excel MVP On Mon, 2 Oct 2006 16:42:01 -0700, sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
I also need to know how to get the correct contents if there are letters and
numbers in all both col.s of sourse and table... "sbellybutton" wrote: I tried both formulas and recieved the same answer then notices the numbers in col.A are not alligned the same as the numbers in col.A on the table sheet! Feeling retarded HELP "Dave Peterson" wrote: Maybe =vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
I put the table in Sheet2 in A1:C216.
I put something in B1 of sheet1 that matched that first column in the table in Sheet2 (A1:A216). Then I used this formula =vlookup(b1,sheet2!a1:c216,2,false) to return the value in column B of sheet2 when B1 matched the value in A1:A216 of sheet2. I'm not sure what you did. You may want to explain it in more detail. sbellybutton wrote: I tried both formulas and recieved the same answer then notices the numbers in col.A are not alligned the same as the numbers in col.A on the table sheet! Feeling retarded HELP "Dave Peterson" wrote: Maybe =vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
Sheet1 (source)
b 22 #N/A 55 #N/A b 26 #N/A 5 3 Sheet 2 (table) b 0 161 d 162 e 163 E 164 g 165 h 166 i 167 j I am trying to fill in blanks on sheet1 according to table.. "Dave Peterson" wrote: I put the table in Sheet2 in A1:C216. I put something in B1 of sheet1 that matched that first column in the table in Sheet2 (A1:A216). Then I used this formula =vlookup(b1,sheet2!a1:c216,2,false) to return the value in column B of sheet2 when B1 matched the value in A1:A216 of sheet2. I'm not sure what you did. You may want to explain it in more detail. sbellybutton wrote: I tried both formulas and recieved the same answer then notices the numbers in col.A are not alligned the same as the numbers in col.A on the table sheet! Feeling retarded HELP "Dave Peterson" wrote: Maybe =vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
get the VLOOKUP function to return the "contents" of a cell?
If there's no match, then you'll see #n/a.
You can hide those errors by: =if(iserror(vlookup(b1,sheet2!a1:c216,2,false)),"" , vlookup(b1,sheet2!a1:c216,2,false)) (It looks for the error and if found returns "" (looks blank). If no error, it retrieves the matching value.) sbellybutton wrote: Sheet1 (source) b 22 #N/A 55 #N/A b 26 #N/A 5 3 Sheet 2 (table) b 0 161 d 162 e 163 E 164 g 165 h 166 i 167 j I am trying to fill in blanks on sheet1 according to table.. "Dave Peterson" wrote: I put the table in Sheet2 in A1:C216. I put something in B1 of sheet1 that matched that first column in the table in Sheet2 (A1:A216). Then I used this formula =vlookup(b1,sheet2!a1:c216,2,false) to return the value in column B of sheet2 when B1 matched the value in A1:A216 of sheet2. I'm not sure what you did. You may want to explain it in more detail. sbellybutton wrote: I tried both formulas and recieved the same answer then notices the numbers in col.A are not alligned the same as the numbers in col.A on the table sheet! Feeling retarded HELP "Dave Peterson" wrote: Maybe =vlookup(b1,sheet2!a1:c216,2,false) and copy down the column Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) sbellybutton wrote: =VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong? Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to equal what is in my table! Help. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how in excel, return page numbers in to cell ?(like date function | Excel Discussion (Misc queries) | |||
| Getting a cell address from Vlookup function in a macro? | New Users to Excel | |||
| VLookUp function to return multiple rows | Excel Worksheet Functions | |||
| Vlookup return 0 when cell is blank | Excel Worksheet Functions | |||
| Excel worksheet function that will return the currency for a cell | Excel Worksheet Functions | |||
Linear Mode
