| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use vlookup when lookup contains number and letters
I'm trying to use vlookup for a table I set up for looking up corresponding
prices based on item numbers. For example one of the item numbers is MGM005, but when I set up the vlookup formula to reference the corresponding column, which is price, it doesn't work. The vlookup only works for the item numbers that are strictly numbers such as 001 or 004. If anyone knows how to resolve this problem that would be great. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use vlookup when lookup contains number and letters
VLOOKUP function is working on both numbers and text.
ma ma no teeth "TGL" wrote: I'm trying to use vlookup for a table I set up for looking up corresponding prices based on item numbers. For example one of the item numbers is MGM005, but when I set up the vlookup formula to reference the corresponding column, which is price, it doesn't work. The vlookup only works for the item numbers that are strictly numbers such as 001 or 004. If anyone knows how to resolve this problem that would be great. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use vlookup when lookup contains number and letters
Do you have the range_lookup argument set to TRUE or 1? If so, change it to
FALSE or 0 (zero). =VLOOKUP(A1,B1:D10,2,0) Biff "TGL" wrote in message ... I'm trying to use vlookup for a table I set up for looking up corresponding prices based on item numbers. For example one of the item numbers is MGM005, but when I set up the vlookup formula to reference the corresponding column, which is price, it doesn't work. The vlookup only works for the item numbers that are strictly numbers such as 001 or 004. If anyone knows how to resolve this problem that would be great. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use vlookup when lookup contains number and letters
"Biff" wrote: Do you have the range_lookup argument set to TRUE or 1? If so, change it to FALSE or 0 (zero). =VLOOKUP(A1,B1:D10,2,0) Biff "TGL" wrote in message ... I'm trying to use vlookup for a table I set up for looking up corresponding prices based on item numbers. For example one of the item numbers is MGM005, but when I set up the vlookup formula to reference the corresponding column, which is price, it doesn't work. The vlookup only works for the item numbers that are strictly numbers such as 001 or 004. If anyone knows how to resolve this problem that would be great. Thanks Thanks that did the trick. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use vlookup when lookup contains number and letters
You're welcome. Thanks for the feedback!
Biff "TGL" wrote in message ... "Biff" wrote: Do you have the range_lookup argument set to TRUE or 1? If so, change it to FALSE or 0 (zero). =VLOOKUP(A1,B1:D10,2,0) Biff "TGL" wrote in message ... I'm trying to use vlookup for a table I set up for looking up corresponding prices based on item numbers. For example one of the item numbers is MGM005, but when I set up the vlookup formula to reference the corresponding column, which is price, it doesn't work. The vlookup only works for the item numbers that are strictly numbers such as 001 or 004. If anyone knows how to resolve this problem that would be great. Thanks Thanks that did the trick. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, how do I change the column headings from letters to number | Excel Discussion (Misc queries) | |||
| count number of letters in a string | Excel Worksheet Functions | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Counting the number of letters in a cell | Excel Discussion (Misc queries) | |||
| How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
Linear Mode
