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

Acer Predator 21X review

These hilarious robot GIFs will be sure to make you smile

Best podcast apps for iPhone & iPad

Nokia 8 : design, caractéristiques techniques, date de sortie