LOOKUP not working

  • Thread starter Thread starter sachinattri
  • Start date Start date
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
 
It is not working. It shows an error in the formula and is highlightin
the B3,Sheet1... text
 
Hi
are you suing the coma or semicolon as delimiter. In the latter case
replace the coma with a semicolon in the complete formula
 
Back
Top