VLOOKUP
 

Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me? Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Maybe you meant to do this:
=VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)

ie match C11 with Sheet2!A2:A410 &
return the corresponding value within Sheet2!B2:B410
in the formula cell

And if you need an error trap to return neat looking blanks: "" for any
unmatched cases instead of ugly #N/As, use this:
=IF(ISNA(MATCH(C11,Sheet2!$A$2:$A$410,0)),"",VLOOK UP(C11,Sheet2!$A$2:$B$410,2,0))

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote:
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me? Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Sarah

It's a little unclear what you are trying to achieve.

The following formula will look at the range A2:A410 in Sheet2
for the value in C11, and then return the data from Column B of Sheet2.

=(VLOOKUP(C11,Sheet2!A2:B410,2,0))

George Gee



"Sarah" wrote in message
...
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me?
Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Hi Sarah,
Are you trying to work on vlookup, if yes, then it should be this. if not
please elaborate a little bit.
=VLOOKUP(C11,Sheet2!A2:C5,2)
--
Thanks
Suleman Peerzade


"Max" wrote:

Maybe you meant to do this:
=VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)

ie match C11 with Sheet2!A2:A410 &
return the corresponding value within Sheet2!B2:B410
in the formula cell

And if you need an error trap to return neat looking blanks: "" for any
unmatched cases instead of ugly #N/As, use this:
=IF(ISNA(MATCH(C11,Sheet2!$A$2:$A$410,0)),"",VLOOK UP(C11,Sheet2!$A$2:$B$410,2,0))

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote:
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me? Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Hi Max,

Thank you!!! That is exactly what I wanted to do Max. However....I have
information in cell C2:C410 and D2:D410 of Sheet2!, which also is dependant
on what i enter into C11 of Sheet1!. How do I overcome this Max?
--
Regards,
Sarah


"Max" wrote:

Maybe you meant to do this:
=VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)

ie match C11 with Sheet2!A2:A410 &
return the corresponding value within Sheet2!B2:B410
in the formula cell

And if you need an error trap to return neat looking blanks: "" for any
unmatched cases instead of ugly #N/As, use this:
=IF(ISNA(MATCH(C11,Sheet2!$A$2:$A$410,0)),"",VLOOK UP(C11,Sheet2!$A$2:$B$410,2,0))

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote:
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me? Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Thank you both Suleman and George, yes that was what i was trying to do.
Sorry for being so unclear.
--
Regards,
Sarah


"George Gee" wrote:

Sarah

It's a little unclear what you are trying to achieve.

The following formula will look at the range A2:A410 in Sheet2
for the value in C11, and then return the data from Column B of Sheet2.

=(VLOOKUP(C11,Sheet2!A2:B410,2,0))

George Gee



"Sarah" wrote in message
...
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me?
Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah

VLOOKUP
 

Welcome, glad it helped.

.. I have information in cell C2:C410 and D2:D410 of Sheet2!,
which also is dependant on what i enter into C11 of Sheet1!.

If you meant to extract info from col C and D in Sheet2
you could use these:
In say, E11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,3,0)
In say, F11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,4,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote in message
...
Hi Max,

Thank you!!! That is exactly what I wanted to do Max. However....I have
information in cell C2:C410 and D2:D410 of Sheet2!, which also is
dependant
on what i enter into C11 of Sheet1!. How do I overcome this Max?
--
Regards,
Sarah

VLOOKUP
 

Thank you so much Max! That works perfectly,

Merry Christmas.
--
Regards,
Sarah


"Max" wrote:


Welcome, glad it helped.

.. I have information in cell C2:C410 and D2:D410 of Sheet2!,
which also is dependant on what i enter into C11 of Sheet1!.

If you meant to extract info from col C and D in Sheet2
you could use these:
In say, E11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,3,0)
In say, F11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,4,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote in message
...
Hi Max,

Thank you!!! That is exactly what I wanted to do Max. However....I have
information in cell C2:C410 and D2:D410 of Sheet2!, which also is
dependant
on what i enter into C11 of Sheet1!. How do I overcome this Max?
--
Regards,
Sarah

VLOOKUP
 

welcome, glad you got the hang of it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote in message
...
Thank you so much Max! That works perfectly,

Merry Christmas.
--
Regards,
Sarah