Hi there,

I am trying to match a list of numbers from column A, with a list of numbers on column B, and the matched numbers to be in column C.

Your quick help regarding this will be greatly appreciated. Thank you!!!

Ad

There is a tutorial on matching here

but it's quite difficult, but you can probably do it

Posted on Dec 04, 2007

Ad

Hi,

A 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Ad

One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)

This will display N/A# if the number can't be found.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)

This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

I think this is a normal behavior of WM. As you go dialing, it goes trying to match it against your contacts list, so that you can easily select the one you want to call without even finishing keying his/her number in. You just have to select the name from the list it offers and, with few operations, make the call.

I might be heavily wrong, though.

Just my 2 cents... Carlos

I might be heavily wrong, though.

Just my 2 cents... Carlos

May 11, 2010 | Motorola Mobility Moto Q

Patrick;

I could not find anything matching the number you provided. I did find an electric saw "RY43006 Chain Saw" here (follow the instructions):

**Homelite/Ryobi.com ***(authorized parts supplier) *

https://www.gardnerinc.com/recons/disclaimer-lg.php - Agree; Choose “Product Line”; “Select OEM” & “Select Catalog” both to “Homelite Consumer Products”. A drop down list appears; self explanatory from here.

The numbers Homelite & Ryobi use do not match the numbers everyone posts. A careful inspection of your saw should find something that matches.

I think with the IPL as a disassembly guide replacement is pretty easy. There are a couple of hoses listed, I suspect one of them failed rather than the pump.

If this is not your saw please provide some different numbers (reply below) and I will try again. Good Luck. HTH

Lou

I could not find anything matching the number you provided. I did find an electric saw "RY43006 Chain Saw" here (follow the instructions):

https://www.gardnerinc.com/recons/disclaimer-lg.php - Agree; Choose “Product Line”; “Select OEM” & “Select Catalog” both to “Homelite Consumer Products”. A drop down list appears; self explanatory from here.

The numbers Homelite & Ryobi use do not match the numbers everyone posts. A careful inspection of your saw should find something that matches.

I think with the IPL as a disassembly guide replacement is pretty easy. There are a couple of hoses listed, I suspect one of them failed rather than the pump.

If this is not your saw please provide some different numbers (reply below) and I will try again. Good Luck. HTH

Lou

Feb 25, 2010 | Ryobi 18-inch Electric Chainsaw Chain Saws

http://www.the12volt.com/installbay/vehicles.asp try this site out and see if it will help you.

Dec 29, 2008 | 1992 Isuzu Rodeo

The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.

Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.

Upper key plus symbol displays:

Right plus symbol on number pad displays:

[Shift] Right plus symbol on number pad displays:

[Alt] [4] [3] displays:

slash/slash/plus displays: //

slash/plus/slash displays: / /

Plus Plus Plus displays:

upper Plus Plus Plus displays:

Shift Right plus plus plus displays:

end of plus test.. thanks.

Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.

Upper key plus symbol displays:

Right plus symbol on number pad displays:

[Shift] Right plus symbol on number pad displays:

[Alt] [4] [3] displays:

slash/slash/plus displays: //

slash/plus/slash displays: / /

Plus Plus Plus displays:

upper Plus Plus Plus displays:

Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

How about this, if you look what paper tray are avaible from the display pannel, is there a matching size paper tray or is the tray you are trying to use another size then lets say LTR. Is it a different size, if so you may have paper jamed behind the paper tray causing a different paper size, if so remove the jamed paper..... Also, the other suggestion are good as well.

Aug 06, 2008 | Konica Minolta DiALTA Di200 Copier

Vlookup: =VLOOKUP(A1,A1:C10,3,FALSE)
1. Lookup_value - A1 the value you want to search.
2. Table_Array - A1:C10 You will only search the lookup_value in the left column which is A1:A10 in this example.
3. Col_Index_Number - If you find a matching value give me column 3. Since A1=A1 it will give me C1. In this example 1 is A, 2 is B and 3 is C.
4. Range_lookup - I always choose false which is exact match. True will give you approximate match and its not always correct.
Vlookup is used when you have a list of values and you want additional values that exist in other fields. You will get those values only for the fields that you search for. In your example you can get the address by running vlookup at the names, it is also good way to search duplicates.
Q2 is very simple, on field D1 just type:
=A1 & " " & B1 & " " & C1
Just drag it or double click on the drag square
Let me know if you have any other questions
Daniel

Sep 24, 2007 | Microsoft Office Standard for PC

VLOOKUP is to Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.
Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.
If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.
You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.
The values in the first column of table_array can be text, numbers, or logical values.
Uppercase and lowercase text are equivalent.
Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.
Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
Remarks
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.
If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.
If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value.

Aug 30, 2007 | Microsoft Office Standard for PC

Aug 20, 2013 | Microsoft Office Standard for PC

31 people viewed this question

Usually answered in minutes!

×