| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with not exactly matching numbers
I need to often match up columns on two spreadsheets. One of the xls has a
reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with not exactly matching numbers
Try:
=MATCH("*" & A1 & "*",C:C,0) A1 is 10 digit C:C are 12 digits HTH "Kelly" wrote: I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with not exactly matching numbers
and ...
=VLOOKUP("*" & A1 & "*",C:C,1,0) also works. "Kelly" wrote: I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with not exactly matching numbers
How should the numbers be formatted? The 12 digits are formatted as
"000000000000" because some of them begin with 0. Some of the 10 digits begin with zero as well. "Toppers" wrote: and ... =VLOOKUP("*" & A1 & "*",C:C,1,0) also works. "Kelly" wrote: I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with not exactly matching numbers
I had the numbers formated as text when I did a quick test but did have
leading zero(s). "Kelly" wrote: How should the numbers be formatted? The 12 digits are formatted as "000000000000" because some of them begin with 0. Some of the 10 digits begin with zero as well. "Toppers" wrote: and ... =VLOOKUP("*" & A1 & "*",C:C,1,0) also works. "Kelly" wrote: I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup with not exactly matching numbers
Thank you! You are a God Send!
"Toppers" wrote: I had the numbers formated as text when I did a quick test but did have leading zero(s). "Kelly" wrote: How should the numbers be formatted? The 12 digits are formatted as "000000000000" because some of them begin with 0. Some of the 10 digits begin with zero as well. "Toppers" wrote: and ... =VLOOKUP("*" & A1 & "*",C:C,1,0) also works. "Kelly" wrote: I need to often match up columns on two spreadsheets. One of the xls has a reference number of 12 digits...the other has 10 digit. The 10 digits are the same as the 12 except they are missing the first and last number. Is there a way to do a vlookup using a "wild" card type feature? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| Vlookup referencing one column that contains part numbers in both. | Excel Worksheet Functions | |||
| using vlookup to find phone numbers online | Excel Discussion (Misc queries) | |||
| Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
| VLOOKUP for a cell with both letters and numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
