LOOKUP not working

[sachinattri]

Can anyone help me with this file. I have attached an example of what
want. Thank yo

Attachment filename: testexcel.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=57194

 

[Frank Kabel]

Hi
first please try to explain your issue in plain text. Don't use
attachments.

but in your case try the following formulas:
F3:
=IF(ISNA(VLOOKUP(B3,Sheet1!$B$1:$E$11,1,0)),"",VLOOKUP(B3,Sheet1!$B$1:$
E$11,1,0))

G3:
=IF(ISNA(VLOOKUP(B3,Sheet1!$B$1:$E$11,2,0)),"",VLOOKUP(B3,Sheet1!$B$1:$
E$11,2,0))
and copy both formulas down

 

[sachinattri]

It is not working. It shows an error in the formula and is highlightin
the B3,Sheet1... text

 

[Frank Kabel]

Hi
are you suing the coma or semicolon as delimiter. In the latter case
replace the coma with a semicolon in the complete formula