Match Formula

cable

New Member
Joined
Feb 27, 2002
Messages
6
Hi

I am trying to use the Match formula but need it explained in laymans terms.
I have two tables of data and need to return a value by matching another.

i.e. Table 1 contains Account Number and a value, Table 2 contains Account number and I need it to contain the same value alongside the matching Account Number.Is this the best formula to use?

Many thanks
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Hi - Welcome to the board

Match will return the row number of the matching value, not the value itself. In this case you should use VLookUp(). Try VLookUp and if you run into trouble post back here.
 
Upvote 0
Thanks Jacob

I'm not sure I understand the V Lookup because I'm working with 2 tables.
I need to say if column A (Table 1) = Column A (Table 2) then put Column B (Table1) value in Column B (Table 2)

Does this make sense?
 
Upvote 0
You would want to do something like this.

=Vlookup(A1,'Sheet1!A1:B500,2,false)

A1= represents the value you are looking for in the second parameter range

'Sheet1!A1:B500
Is the range you want to search for the first value in. You need to include the range for where the search value is, as well as the range for the return value(B500).
2 represents which value to return, in this case the 2 column of the range selected(You can do areas larger then 2 columns)
False
Tells the formula to only return exact matches.

Hope this helps.
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top