show results in diff cells

good day i need to do the following
if any row in colum A is lets say Apple (there would only b one instence of the word apple but could be anywhere in colum A) then look at the corresponding row in colum B and post the information in colum B on a diff Excel doc. i'm guessing it easy but i haven't had coffee yet. any help would be great thx!

Originally Posted by blackstar

good day i need to do the following
if any row in colum A is lets say Apple (there would only b one instence of the word apple but could be anywhere in colum A) then look at the corresponding row in colum B and post the information in colum B on a diff Excel doc. i'm guessing it easy but i haven't had coffee yet. any help would be great thx!

I think you would need to use the vlookup functions.

=vlookup({Cell you want to lookup},{range you want to lookup},{which row you want to return, {else if you dont find anything return a something})

open both workbooks then in the cell that you want the value to return to type this.

=vlookup

Then select the cell which you want to lookup.

I want to look up the vlaue which is in b1
eg. =vlookup(b1,

then click on the other workbook and select the range that you want to lookup

My other book with the list is called book2 with a range called 'List'.
Eg. =VLOOKUP(B1,book2.xls!list,

then type in the number of the column you want to return

I would then like to return the value in the second column of my list of figures
eg.=VLOOKUP(B1,book2.xls!list,2,FALSE)

hope this helps you