Vlookup Error

[Farooqi]

Hi,

I am getting a #N/A error when i try to use the formula,

=VLOOKUP(G20,'Protection Details'!$A$2:$D$112,2,FALSE)

In turn Cell "G20"in the above has this formula IF(B20=0,"",LEFT(B20,
SEARCH(" ",B20,1))) ----// which is extracting the left word from the cell
B20//----

The cell in the above "B20" has this one HLOOKUP($G$15,'Span
Wise'!$B$3:$DS$248,2,FALSE) ---/// Hlookup is fetching the data from
othersheets///---

Pls anybody have any idea in this, help me.
Thanks

 

[Ashish Mathur]

Try this

=VLOOKUP(1*G20,'Protection Details'!$A$2:$D$112,2,FALSE)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com