VLOOKUP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 26 Dec 2007 10:14 GMT

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)))

Signature

Regards,
Sarah

Reply to this Message

Max - 26 Dec 2007 10:59 GMT

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)),"",VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0))

Adapt to suit ..

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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)))

Reply to this Message

Suleman Peerzade - 26 Dec 2007 11:48 GMT

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)

Signature

Thanks
Suleman Peerzade

> Maybe you meant to do this:
> =VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)
[quoted text clipped - 14 lines]
> >
> > =IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0)))

Reply to this Message

Sarah - 26 Dec 2007 20:46 GMT

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?

Signature

Regards,
Sarah

> Maybe you meant to do this:
> =VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)
[quoted text clipped - 14 lines]
> >
> > =IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0)))

Reply to this Message

Max - 26 Dec 2007 22:13 GMT

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)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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?

Reply to this Message

Sarah - 27 Dec 2007 00:17 GMT

Thank you so much Max! That works perfectly,

Merry Christmas.

Signature

Regards,
Sarah

> Welcome, glad it helped.
>
[quoted text clipped - 11 lines]
> > dependant
> > on what i enter into C11 of Sheet1!. How do I overcome this Max?

Reply to this Message

Max - 27 Dec 2007 00:48 GMT

welcome, glad you got the hang of it.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thank you so much Max! That works perfectly,
>
> Merry Christmas.

Reply to this Message

George Gee - 26 Dec 2007 11:01 GMT

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

> 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?
[quoted text clipped - 3 lines]
>
> =IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0)))

Reply to this Message

Sarah - 26 Dec 2007 20:48 GMT

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

Signature

Regards,
Sarah

> Sarah
>
[quoted text clipped - 14 lines]
> >
> > =IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0)))

Reply to this Message

Rate this thread: