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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?