# How to MATCH a name in one range with another range?

#### brooksc29

##### Active Member
How can I write a formula that says to match the cell A2 (it has text in it) in the range OFFT2016, with the same text in row A2:A1000 of STOLENBASE, and return the number in column H of STOLENBASE?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### FDibbins

##### Well-known Member
Perhaps this will get you started, I am assuming that your lookup data in on another sheet?

=vlookup(A2,STOLENBASE!\$A\$2:\$H\$1000,8,0)

Replies
3
Views
271
Replies
1
Views
401
Replies
1
Views
499
Replies
3
Views
597
Replies
2
Views
324

1,190,855
Messages
5,983,238
Members
439,833
Latest member
CDaviess

### 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?

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