| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using "Vlookup" across 2 Spreadsheets
I am trying to create a spreadsheet that takes a value from cell 6 of
"Product Price Levels" if the value in cell A4 of my working spreadsheet is found in the range between A8 and I3000 of the "Product Price Levels" spread sheet. I receive a "#N/A" error and I do not know why. Formula as it is written: =VLOOKUP($A$4,'Product Price Levels.xls'!$A$8:'Product Price Levels.xls'!$I$3000,6,FALSE) Can you use "Vlookup" across 2 spreadsheets? If not, what do you suggest? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using "Vlookup" across 2 Spreadsheets
Hi,
could you post an example, cell 6 ?? which column??, anyway vlookup works looking into the first column, an example will help to get you a formula "wormburner" wrote: I am trying to create a spreadsheet that takes a value from cell 6 of "Product Price Levels" if the value in cell A4 of my working spreadsheet is found in the range between A8 and I3000 of the "Product Price Levels" spread sheet. I receive a "#N/A" error and I do not know why. Formula as it is written: =VLOOKUP($A$4,'Product Price Levels.xls'!$A$8:'Product Price Levels.xls'!$I$3000,6,FALSE) Can you use "Vlookup" across 2 spreadsheets? If not, what do you suggest? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using "Vlookup" across 2 Spreadsheets
Your cell referencing is incorrect.
=VLOOKUP($A$4,'Product Price Levels'!$A$8:$I$3000,6,FALSE) Sheet name only needs to appear once, and don't put the ".xls" extension in there. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "wormburner" wrote: I am trying to create a spreadsheet that takes a value from cell 6 of "Product Price Levels" if the value in cell A4 of my working spreadsheet is found in the range between A8 and I3000 of the "Product Price Levels" spread sheet. I receive a "#N/A" error and I do not know why. Formula as it is written: =VLOOKUP($A$4,'Product Price Levels.xls'!$A$8:'Product Price Levels.xls'!$I$3000,6,FALSE) Can you use "Vlookup" across 2 spreadsheets? If not, what do you suggest? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
