Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Problem
I am having problems with a vlookup formula. My component for this formula
is the following. By clicking on a dropdown box, the user will select from a list in cell [A3], then one cell over in [B3] a corresponding number will display. Then on a separate worksheet, I have named several ranges in this sheet. Next, I have a formula in [B4] that concatenate the word (Table) with the information in B3. All of the above explanations are secondly formulas to what I need for my real answer. I have a vlookup formula that uses the cell B4 that matches my range name. Example: 1. A3 = Toyota 2. B3 = 123 3. B4 = Table123 formula example is =concatenate (€śTable€ť, B3) Formula for lookup function is: 1 Vlookup(D10,B4,2) What I want to see is a answer of say 12 But what Im getting is a answer of (#N/A) Can somebody help let me know what Im doing wrong in this equation. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with this formula | Excel Worksheet Functions | |||
I have a problem with my Formula. | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) | |||
problem with formula | Excel Discussion (Misc queries) | |||
Formula problem | Excel Worksheet Functions |