Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference in another workbook related to the name of material
what's wrong in the picture?
I used vlookup (have no idea if it is right, cause I don't know the meaning of A2, which should be "Lookup_value" The value to search in the first column of the table array. Lookup_value can be a value or a reference. what is this mean?????) Anyway, here-s my formula: =VLOOKUP(A2,[Book1_old.xls]Sheet1!$C$1:$G$1602,7,FALSE) ,[Book1_old.xls]Sheet1!$C$1:$G$1602 - this is the range area from the other workbook 7 - the column G from where I want to get the value Lookup value -? I want to take the value that correspond to a certain name of material (for example:"BOLTS") which is somewhere in the A column (the row position is changing almost daily)! Does anyone have enough time to help me bring some light in this issue, please??? I really need it!!! Thanks, Liliana and here's my result:"#N/A" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
reference to consecutive worksheets within a workbook | New Users to Excel | |||
Pulling data from another workbook | Excel Worksheet Functions | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |