Lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. In Excel 97, I need to compare a cell value from a lookup table and get the associated value. i.e
if the cell value value is 1-10, return 1, if 2-20, return 2, etc
I guess I’d create a lookup table somewhere on the spreadheet and preferably name it
I’ve tried VLOOKUP function but can’t get it to work. Can anyone help please? A sample function or formula would be exceptionally helpful. Thanks. Shaoon.
 
Try This:

Create a table as folowing
10 1
20 2
30
-----Original Message-----
Hi. In Excel 97, I need to compare a cell value from a
Click to expand...
lookup table and get the associated value. i.e:
if the cell value value is 1-10, return 1, if 2-20, return 2, etc.
I guess Iâ?Td create a lookup table somewhere on the
Click to expand...
spreadheet and preferably name it.
Iâ?Tve tried VLOOKUP function but canâ?Tt get it to work.
Click to expand...
Can anyone help please? A sample function or formula would
be exceptionally helpful. Thanks. Shaoon.
 
Try This
Create a table A1 to B10
10 1
20 2
30 3
40 4
50 5
60 6
70 7
80 8
90 9
100 10

then enter into a call
=VLOOKUP(D1,A1:B10,2)

-----Original Message-----
Hi. In Excel 97, I need to compare a cell value from a
Click to expand...
lookup table and get the associated value. i.e:
if the cell value value is 1-10, return 1, if 2-20, return 2, etc.
I guess Iâ?Td create a lookup table somewhere on the
Click to expand...
spreadheet and preferably name it.
Iâ?Tve tried VLOOKUP function but canâ?Tt get it to work.
Click to expand...
Can anyone help please? A sample function or formula would
be exceptionally helpful. Thanks. Shaoon.
 
Back
Top