Help formula that returns a text string from another sheet
 

I have a random list of products in sheet 1 cells A9, 10, 11 and 12 that have
been put there by a formula.
Alongside I have empty cells B9, 10, 11 and 12.
I have another table in sheet 2 with the same list of products as sheet 1
column A but this time in cells J2-J50. In column K, alongside each entry
for column J, there is a specific matched product with a text 'name' (ie
Fred).
I would like to look down cells J2-J50 for any occurance of that product in
A9-A12 and where appropriate copy the text name that appears in the adjacent
cells K2-K50 into B9-B12 for up to a maximum of 4 names. For example, if
only 3 products are put into A9, A10 and A11 with A12 left empty by my
original formula. Cells B9, B10 and B11 must return appropriate text names in
column B (ie Fred in B9, Tom in B10, Bill in B11, and B12 = empty (no
appropriate name found).
Can anyone help me please?
--
Stuart K

Help formula that returns a text string from another sheet
 

Maybe

=IF(ISNA(VLOOKUP(A9,Sheet2!$J$2:$K$50,2,FALSE)),"N o match
found",VLOOKUP(A9,Sheet2!$J$2:$K$50,2,FALSE))

Mike

"Stuart k" wrote:

I have a random list of products in sheet 1 cells A9, 10, 11 and 12 that have
been put there by a formula.
Alongside I have empty cells B9, 10, 11 and 12.
I have another table in sheet 2 with the same list of products as sheet 1
column A but this time in cells J2-J50. In column K, alongside each entry
for column J, there is a specific matched product with a text 'name' (ie
Fred).
I would like to look down cells J2-J50 for any occurance of that product in
A9-A12 and where appropriate copy the text name that appears in the adjacent
cells K2-K50 into B9-B12 for up to a maximum of 4 names. For example, if
only 3 products are put into A9, A10 and A11 with A12 left empty by my
original formula. Cells B9, B10 and B11 must return appropriate text names in
column B (ie Fred in B9, Tom in B10, Bill in B11, and B12 = empty (no
appropriate name found).
Can anyone help me please?
--
Stuart K