I received an #N/A error. I think this might be on the right track to
helping me....can you elaborate a bit more? I am referencing the main
spreadsheet as alternate, and using A:G for the table array because A
is what i need it to reference in the main spreadsheet and G is the
prices on the alternate, using col_index_num 7 as that is the column
number, all with your formula and im receiving that error.



Smilingout_loud wrote:
Have you tried using a VLOOKUP (using the fx button under the catagory =
Lookup & Reference)? Make sure you are able to sort in ascending order by
the Product ID on both tabs. Then using column A from the Main spreadsheet
as the Lookup Value, then on the alternate tab/spreadsheet use the columns
A:B for the table array, the col_index_num will be "2" which will be
referencing column B ( the prices), and you should set the Range_lookup to
false because you want it to utilize exact matches on the Product IDs. Your
formula would look something similar to this
=VLOOKUP(A2,alternate!A:B,2,FALSE). Good Luck!!
"ChrisB" wrote:


Dave O wrote:
It's likely very possible, but we'd need to see some sample data so we
know what data points are available to work with. Please post sample
data.


Ok... My main spreadsheet (tab delimited file) I have it setup as
follows:

A B C
D

ProductID49483 Brief Description Image.jpg 3.00
ProductID93094 Brief Description Image.jpg 5.00
ProductID30940 Brief Description Image.jpg 8.00

my alternate spreadsheet (tab delimited file) is as follows:

A B

ProductID49483 4.50
ProductID93094 8.50
ProductID30940 9.50


I want to make it so that I can Import my alternate spreadsheet into my
main spreadsheet, but I only want it to alter column D on my main
spreadsheet (changing prices). I need a macro, or a formula which will
import column B from my alternate spreadsheet into column D in my main
spreadsheet. I also need this macro/formula to be able to correspond
the price with the correct productID...so it changes the correct
product to its designated price.

Any Ideas guys???