1st time post, need help trying to have excel generate a cost based on a code I select.
Example I want to pick from column A and instead have cell show value from B.
So if I pick 11200 I want cell to show $121.00
A B
11200 $121.00
11201 $27.00
11300 $97.00
11301 $132.00
11302 $158.00
Try
Cell E2:=VLOOKUP(D2,$A$2:$B$10,2,0)
Cell D2: You selection input
//Ola
Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
It saves time, to skip already solved threads.
if you have your code in cell C1, then in C2 you could use:
=VLOOKUP($C$1,$A$1:$B$5,2,FALSE)
format cell C2 as currency, and it should be what you are looking for
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thousands of thanks for all your assistance. Exactly what I was in need of.
You are welcome !
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
You are welcome !
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks