VLOOKUP

[Sarah]

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

 

[Max]

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

 

[George Gee]

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

 

[Suleman Peerzade]

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)

 

[Sarah]

Hi Max,

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

 

[Sarah]

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

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

 

[Max]

Welcome, glad it helped.

.. I have information in cell C2:C410 and D2410 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)

---

 

[Sarah]

Thank you so much Max! That works perfectly,

Merry Christmas.
--
Regards,
Sarah

Welcome, glad it helped.

.. I have information in cell C2:C410 and D2410 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]

welcome, glad you got the hang of it.