Thread
:
Lookup Function
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Lookup Function
Change your table to:
A B
1 0 0.12
2 8499 0.14
3 13499 0.16
then with your data in D3 use the formula:
=LOOKUP(D3,A1:A3,B1:B3)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"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
Sandy Mann
View Public Profile
Find all posts by Sandy Mann