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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
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.
 

cable

New Member
Joined
Feb 27, 2002
Messages
6
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?
 

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

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
Top