Hi. I am new here, but search did not seem to yield an answer to this question. Suppose I have an array such as below. When a user enters a value in a cell, such as 8 that matches a value in column A, I want a function to return the value from the same row in column B (1800).
1 75.00
2 150.00
3 300.00
4 450.00
5 600.00
6 900.00
7 1,200.00
8 1,800.00
9 2,400.00
10 3,000.00
11 4,500.00
12 6,000.00
13 9,000.00
14 12,000.00
15 18,000.00
16 24,000.00
17 30,000.00
18 45,000.00
Hi,
Try in D1:
=VLOOKUP(C1,A1:B1,2,FALSE)
Where C1 is the entered value.
HTH
Steve
Good day,
Use the Vlookup formula in Cell D1 and drag below
where C1 is the entered value
Please Login or Register to view this content.
Press the star icon if you like this post
Last edited by Ace_XL; 06-19-2012 at 12:54 PM.
you might want to use the following version of steve's formula (with absolute referencing to boot):
=VLOOKUP(C1,$A$1:$B$18,2,FALSE)
Last edited by icestationzbra; 06-19-2012 at 12:54 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Hi,
Use Vlookup formula for the same.
check the attached file.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks