im not sure ... lookup maybe??

A1058

New Member
Joined
Sep 13, 2006
Messages
46
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...
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
Sounds to me like a simple VLOOKUP will work.

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

Watch MrExcel Video

Forum statistics

Threads
1,109,054
Messages
5,526,507
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top