Thread
:
Lookup Function
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Lookup Function
8499 and 8500 are the same thing
=vlookup(6000,a2:b4,2)
5500 .012
8500 .014
13500. .016
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"noodlehounds" wrote in message
...
I am looking for the formula to look up values/range in column A and
provide
the correlating value in column B
ie
A B
1 8499 0.12
2 8500 - 13499 0.14
3 13500 0.16
Thanks in advance!!!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett