Data lookup on 2nd excel sheet.

[radink]

Hey all,

I'm importing a report from a CSV file. Once in, it has a column with
project numbers in it. I would like to have another cell look in the
project number cell and then get the project name and client from a
2nd excel file. Is this something that can be done? I don't want to do
it in access. Thanks!

 

[Guest]

If the data in the lookup worksheet is arranged as a table you can use a
VLOOKUP worksheet function to look up the values you need.

=VLOOKUP(A1, [LookupFileName.xls]Sheet1!$A$1:$E$25,2)

In the example above the value you're looking up is in cell A1, the table
where you are lookup up the matching value is in a file named
LookUpFileName.xls, in Sheet 1, cells A1 through E25, with the return value
to be found located in column 2 of the lookup table

By default the VLOOKUP does an approximate match, so you'll want to sort the
lookup table in ascending order, or to have it do an exact match add True as
the optional 4th argument value.

=VLOOKUP(A1, [LookupFileName.xls]Sheet1!$A$1:$E$25,2,TRUE)

 

[radink]

If the data in the lookup worksheet is arranged as a table you can use a
VLOOKUP worksheet function to look up the values you need.

=VLOOKUP(A1, [LookupFileName.xls]Sheet1!$A$1:$E$25,2)

In the example above the value you're looking up is in cell A1, the table
where you are lookup up the matching value is in a file named
LookUpFileName.xls, in Sheet 1, cells A1 through E25, with the return value
to be found located in column 2 of the lookup table

By default the VLOOKUP does an approximate match, so you'll want to sort the
lookup table in ascending order, or to have it do an exact match add True as
the optional 4th argument value.

=VLOOKUP(A1, [LookupFileName.xls]Sheet1!$A$1:$E$25,2,TRUE)
--
Kevin Backmann

Hey all,

I'm importing a report from a CSV file. Once in, it has a column with
project numbers in it. I would like to have another cell look in the
project number cell and then get the project name and client from a
2nd excel file. Is this something that can be done? I don't want to do
it in access. Thanks!

Thanks Kevin!

One wierd thing is that when i get it working, and then copy and paste
the formula into a new cell, it pops up an open dialog asking for
where that file is. Any idea why, even though it's coded correctly?