Matching numbers from 2 columns

[sparkymoc]

I have two sets of data on one spreadsheet.
On the left side of the sheet I have a list of transactions with one of the columns a value (i.e. a number).
On the right side of the sheet I have another set of transactions that also has a column with numbers in it.
A lot of the figures (numbers) on the left side correspond to the figures on the right side and I just want to be able to match/ pair all the figures/ transactions.
I usde the basic Sort function to speed things up slightly but was just wandering if there is a quicker way of matching up the transactions?

 

[WinteE]

Try conditional format. Select the option 'Formula is' instead of 'Cell value is' and enter a VLOOKUP function on the column you want to look for a match.

For example :

When there are numbers in column A that should match with numbers in column B the formula would be =A1<>VLOOKUP(A1,B:B,1,0)

Success,
Erik

 

[sparkymoc]

Thanks for that.

However, my excel knowledge is basic and im not familiar with somne of the terms you use. Im not familiar with the vlookup function. Is it easy to use? What does the 1 and the 0 in the formula mean?

Also, if I use this function will it only match up with that particular column? I have other data relating to that column in the column next to it i.e. Account name, account number. does that mean that these columns would not be still alongside the numbers column that I wanted mtached?

Sorry if i m not making much sense!

 

[WinteE]

Hi,

=VLOOKUP(Lookup_value, Table_array, Col_index_num, Range_lookup)

Lookup_value = The value you want to search for in another column

Table_array = The range you want to search a value based on Lookup_value. The most left column is the column where Lookup_value is searched in.

Col_index_num = Which column in the range a value should be returned. The most left column is 1 ( returns the Lookup_value if found ), and so on to the most right column in the range.

Range_lookup = True (1) or False (0), False means the Lookup_value has to be found otherwise #N/A is returned. True will look for the nearest value to Lookup_value.

Hope this helps,

Erik

 

[sparkymoc]

OP.
Do you think if I sent a small sample from a spreadsheet to you that you could help me? Just so that you could see what I want to do as I dont think I am explaining myself very well!

 

[WinteE]

I'll have a look at it. Please use the "Ask your question" link on my site.