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 1100 199 2200 299 3300 399 4400 499 5500 599 6
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.
iMac Pro review
Illustrator Charles Williams on how to create magazines and book covers
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.