VLOOKUP

  • Thread starter Thread starter Sarah
  • Start date Start date
S

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)))
 
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 ..
 
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 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)
 
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?
 
Thank you both Suleman and George, yes that was what i was trying to do.
Sorry for being so unclear.
--
Regards,
Sarah


George Gee said:
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
Click to expand...
 
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!.
Click to expand...

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)

---
 
Thank you so much Max! That works perfectly,

Merry Christmas.
--
Regards,
Sarah


Max said:
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!.
Click to expand...

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)

---
Click to expand...
 
Back
Top