VLOOKUP problem

[jamiee]

Hi

I have a table that has the following info

Mega 45
A 40
B 12
C 10
D 10

When I use vlookup I can get the respective data for the values of 'B'
'C' and 'D'. However, I can't get the values for 'Mega' and 'A'. For
'Mega' I get the data for the last value in the tabel.

Does anyone know why this is happening, is it because Mega is a string
not a character?, how do I change the vlookup statement to make this
work?

Any help appreciated.

 

[Bob Phillips]

Jaimee,

Are you using
=VLOOKUP(lookup_Vale, lookup_table, 2, FALSE)

Not the FALSE at the end

 

[Paul Corrado]

Jamiee,

Possibly you are not adding False to the Range Lookup field, the last one in
the formula

=VLOOKUP("value",A1:B5,2,false) should work

HTH

PC

 

[mlindsay]

TRY SOMETHING LIKE:

=VLOOKUP(D1,A1:B5,2,FALSE)

Where "D1" is value searching for
"A1:B5" table with your two columns of data
"2" means return data from column 2 of table
"False" means exact match only!

--
Michael R. Lindsay NCT
(e-mail address removed)
(An old dog still trying
to learn new tricks...)

(Do you remember:
2 MHz 8-Bit CPU?s
64K maximum Ram
300 Baud Acoustic Couplers
Data storage on Audio Cassette tapes)

 

[Alan Beban]

It's good form and saves the responders' time if you post your failing
formula.

Alan Beban

 

[Aaron]

Hey Jamie!!

The last argument of the vlookup function refers to if the
formula is based on asending data as you looking up alpha
characters make sure it's declared as false.

Hope it helps

Aaron