Trouble with vLookup

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