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