Not sure if I am using the right formula however this is what I want to
achieve.

On "Main" spreadsheet I have a long list of Names in column (B:B) - not in
assending order and a separate workbook i will call "Data" with similiar
names however this list is shorter and does not all included the names in
the MAIN spreadsheet - this sheet I have in alphabetical order.

vlookup(B:B,C3:F30,4,false) - this didn't work - vlookup(B:B,C3:F30,4) -this
worked when B:B was smaller then the array and with both in assending.

I want to look up the name in column B "main spreadsheet" I can reference to
a single cell if need to, I want to go and search in my "Data" workbook array
B3:E30 the name is in the "B" once find the match, I want to return the value
in the 4 column in the array on my Main spreadsheet and if the name is not
found than enter "0" in my "Main" spreadsheet.

Thank you

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1

Hi

Try
In workbook Data
=IF(ISERROR(VLOOKUP(B1,[Main.xls]Sheet1!$B$3:$E$30,4,0)),0,
VLOOKUP(B1,[Main.xls]Sheet1!$B$3:$E$30,4,0))
copy down as far as required

This assumes you do have a separate workbook called Main.xls and that
your data is on sheet - change accordingly.
If they are not separate workbooks, but separate sheets in the same
workbook, then change
[Main.xls]Sheet1!$B$3:$E$30 to Main!$B$3:$E$30

--
Regards

Roger Govier


"lcks via OfficeKB.com" <u22747@uwe wrote in message
news:61667fa08b643@uwe...
Not sure if I am using the right formula however this is what I want
to
achieve.

On "Main" spreadsheet I have a long list of Names in column (B:B) -
not in
assending order and a separate workbook i will call "Data" with
similiar
names however this list is shorter and does not all included the
names in
the MAIN spreadsheet - this sheet I have in alphabetical order.

vlookup(B:B,C3:F30,4,false) - this didn't work -
vlookup(B:B,C3:F30,4) -this
worked when B:B was smaller then the array and with both in
assending.

I want to look up the name in column B "main spreadsheet" I can
reference to
a single cell if need to, I want to go and search in my "Data"
workbook array
B3:E30 the name is in the "B" once find the match, I want to return
the value
in the 4 column in the array on my Main spreadsheet and if the name is
not
found than enter "0" in my "Main" spreadsheet.

Thank you

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1