| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup help
What is from with this Vlookup? I formatted all cells as text, copy paste
special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
What is in D7?
Instead of D7 in your VLOOKUP shouldn't you have A7 or C7 (custno)? I am assuming first set is your 'Data' sheet and second set where you have your VLOOKUP in D7... "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
Sorry, should have stated the first column is actually Column C. I did not
start the data at column A. -- AcctCA755 "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
It looks like you need the formula to read VLOOKUP(B7,Data!B7:D11,3,FALSE)
The Lookup_value is the cell that links both sets of information. -- GD "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
Here is the info again, I started the data at Column A.
Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(C7,Data!A7:C11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
The value in C7 may not be text, so try it like this:
=VLOOKUP(C7&"",Data!A$7:C$11,3,FALSE) Alternatively, you might have numbers in your data sheet and text in your other sheet, so try it like this: =VLOOKUP(C7+0,Data!A$7:C$11,3,FALSE) Hope this helps. Pete On Dec 11, 5:33*pm, AcctCA755 wrote: Here is the info again, I started the data at Column A. Cust No Name * *Item 12582 * smith * Bean 5400 * *Jones * Corn 9988 * *Brown * apple 2255 * *Long * *Dress 22556 * Shaw * *Shirt Cust No Name * *Cust No Item 12582 * smith * 12582 * =VLOOKUP(C7,Data!A7:C11,3,FALSE) 5400 * *Jones * 5400 * * 9988 * *Brown * 9988 * * 2255 * *Long * *2255 * * 22556 * Shaw * *22556 Thanks * -- AcctCA755 "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No * *Name * *Item 12582 * * *smith * Bean 5400 * * * Jones * Corn 9988 * * * Brown * apple 2255 * * * Long * *Dress 22556 * * *Shaw * *Shirt Cust No * *Name * *Cust No Item 12582 * * *smith * 12582 * =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 * * * Jones * 5400 * * 9988 * * * Brown * 9988 * * 2255 * * * Long * *2255 * * 22556 * * *Shaw * *22556 * Thanks -- AcctCA755- Hide quoted text - - Show quoted text - |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
Thanks everyone for your help, the problem has been solved. I formatted the
spreadsheet to General, instead of text. -- AcctCA755 "Pete_UK" wrote: The value in C7 may not be text, so try it like this: =VLOOKUP(C7&"",Data!A$7:C$11,3,FALSE) Alternatively, you might have numbers in your data sheet and text in your other sheet, so try it like this: =VLOOKUP(C7+0,Data!A$7:C$11,3,FALSE) Hope this helps. Pete On Dec 11, 5:33 pm, AcctCA755 wrote: Here is the info again, I started the data at Column A. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(C7,Data!A7:C11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755- Hide quoted text - - Show quoted text - |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup help
Well, thanks for letting us know.
Pete "AcctCA755" wrote in message ... Thanks everyone for your help, the problem has been solved. I formatted the spreadsheet to General, instead of text. -- AcctCA755 "Pete_UK" wrote: The value in C7 may not be text, so try it like this: =VLOOKUP(C7&"",Data!A$7:C$11,3,FALSE) Alternatively, you might have numbers in your data sheet and text in your other sheet, so try it like this: =VLOOKUP(C7+0,Data!A$7:C$11,3,FALSE) Hope this helps. Pete On Dec 11, 5:33 pm, AcctCA755 wrote: Here is the info again, I started the data at Column A. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(C7,Data!A7:C11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755 "AcctCA755" wrote: What is from with this Vlookup? I formatted all cells as text, copy paste special value all data, however, I don't receive the data in column 3. The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE) The spreadsheets are below. Cust No Name Item 12582 smith Bean 5400 Jones Corn 9988 Brown apple 2255 Long Dress 22556 Shaw Shirt Cust No Name Cust No Item 12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE) 5400 Jones 5400 9988 Brown 9988 2255 Long 2255 22556 Shaw 22556 Thanks -- AcctCA755- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
