Is there a way in Excel that user can select the option/product via drop down box, and the price of the item will reflect on the next column as per my illustrated attachment?
Is there a way in Excel that user can select the option/product via drop down box, and the price of the item will reflect on the next column as per my illustrated attachment?
see attached (check column C for formula)
Example.xlsm
Click on the star if you think I helped you
Hello Yonggie,
Welcome to the Forum.
Place this Formula in Cell C2 and Copy down as far it is required.
=IF(A2="","",IFERROR(VLOOKUP(A2,$H$2:$I$6,2,FALSE),""))
Or you could use adyteo's formula like this: =IFERROR(INDEX(I:I,MATCH(A2,H:H,0)),"")
Regards
Last edited by Winon; 04-03-2014 at 02:29 AM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
thank you, let me give it a try~
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks