Excel Lookup??

  ihbuk1 12:22 22 Dec 03

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 03

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.

Microsoft Surface PC release date, price and specs: All-in-one Surface PC to directly rival iMac

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

Apple's event invitations decoded: A look back at 16 of Apple's most cryptic invites | Clues in…