VLOOKUP formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use this function. It works for the first cell and a few odd
ones here and there but isn't working on all of them. Does anyone know how to
use this function?
 
Lots of us do...

However, given your description, we don't have any idea how you've set
up your formula, nor what type of data you're using nor how your data is
structured, so it would be pretty difficult to give you any specific
help...
 
Usually, the most common cause of erratic VLOOKUP results is using a
range_lookup argument of TRUE or 1 (or if omitted it defaults to TRUE). Try
setting the range_lookup argument to either 0 or FALSE:

=VLOOKUP(A1,C:D,2,0)
=VLOOKUP(A1,C:D,2,FALSE)

If that doesn't solve your problem then you'll need to show us the *exact*
formula you're using and a give us detailed explanation of what you're
trying to do.
 
I have a list of 3 letter codes and the names they represent in a table. I
have a list of about 300 codes some of which are reapeated and I wanted to
display the names next to them by having excel refer to the table. Does that
make sense?
 
Hi - sounds like you may be copying the formula into a number of other cells.
If this is the case then make sure that the table_array part of the formula
(the bit after the 1st comma) is an absolute reference - i.e $A$1:$B$20 ,
otherwise it will change as you copy the formula and give you errors.

TV.
 
Back
Top