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

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.

Farooqi;308656 Wrote:
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)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86294

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Farooqi" wrote in message
...
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