Excel Lookup??

  ihbuk1 12:22 22 Dec 2003

I have a table with a range of numbers e.g. below, so that if I type a number in a cell it will look that number up and if it falls within the range replace it with the appropriate value in the third column. Any ideas??

0 99 1
100 199 2
200 299 3
300 399 4
400 499 5
500 599 6

  VoG II 12:44 22 Dec 2003

Assuming your table is A1:C18 and you type a number into F3 then the following formula (in another cell) will return the corresponding value from column C

=VLOOKUP(F3, A1:C18, 3, FALSE)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)