# im not sure ... lookup maybe??

#### A1058

##### New Member
hello hoping someone can help me out....
in column "N" i have 100 product descriptions and in column "M" i gave them all a number 1-100. in column "L" the user puts the number that matches the product description from the list. i am needing to do in laymans terms now.... IF L2 = # find matching # in column M then and report the value that resides one cell to the right or offset 0,1.. i hope this is clearly stated... any help would be greatly appreciated...

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sounds to me like a simple VLOOKUP will work.

=VLOOKUP(L2, M1:N100,2,0)

Replies
2
Views
330
Replies
4
Views
222
Replies
1
Views
98
Replies
31
Views
896
Replies
9
Views
461

1,220,981
Messages
6,157,191
Members
451,404
Latest member
Probe

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

### Which adblocker are you using?

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

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