Call on cells from drop down list

[MHevey]

I have a column of 343 items in E, and their corresponding prices in Row E. I've created a drop down list in numerous cells in Column A for items, and I need to formulate it so that the adjacent cell in Column B for each individual drop down will call the correct prices from E. I know this should be simple, but I am absolutely boggled. Any help is very appreciated.

[oeldere]

Please Login or Register  to view this content.

This is a contradiction.

Please post an example of your file, without confidential information, and the desired (expected) result.

[MHevey]

Spreadsheet 1.xlsxYeah, that first one should say column D, and I've attached a sample. That's what I get for rushing.


What I'm looking for is to have the appropriate pricing called into the adjacent cell for whatever item is pulled from the dropdown menu. I will touch up the aesthetics and functionality of everything once I have a working formula.

Thank you for your help.

[oeldere]

See the attached file.

I used VLookup for that.

b2

Please Login or Register  to view this content.

[nenamagic]

I have the following code that calls macros / functions from drop down menu

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$I$2" Then
Select Case Target
Case "CLOSE REQUESTED"
Call Macro1
Case "BF1"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 7
Call Macro2
Case "BF2"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 14
Call Macro2
Case "BF3"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 21
Call Macro2
Case "BF4"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 28
Call Macro2
Case "BF5"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 35
Call Macro2
Case "BF6"
ActiveCell.Offset(0, -1) = ActiveCell.Offset(0, -2) + 42
Call Macro2
Case Else
Call Macro2
End Select
End If


BUT HOW do I make the 2nd line relative:
If Target.Address = "$I$2" Then

I want the target to be anything in Column "I" and cannot seem to be able to set it for the entire column / range and still have it work. help?