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

 

[Simon Lloyd]

Firstly make sure that your LEFT statement is picking out a string and
has no leadin or trailing spaces, secondly make sure the value picked
out exists in your lookup table and lastly make sure that a value exists
in the second column to the right of that value, take a look and post
back.

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

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Ashish Mathur]

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com