Look Up Table in Excel

paul bennett · Mar 12, 2004

Can you have a look up table in a Cell? and if so, how do you set up a look
up Table?

Thanks

Frank Kabel · Mar 12, 2004

Hi Paul
not quite sure what you're trying to do. You may give an example?

Dave Peterson · Mar 13, 2004

David McRitchie has a lot of notes about =vlookup() at:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

(and don't forget excel's help, too.)

Dave Hawley · Mar 13, 2004

Hi Paul

No, you must use at *least* 2 cells, ie

A1="Dog"
B1="Lassie"

Then, using something like
=VLOOKUP(A1:B100,"Dog",2,False)

Would return "Lassie"

Details on the VLOOKUP can be found here
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Frank Kabel · Mar 13, 2004

Hi Dave
you probably meant
=VLOOKUP("Dog",A1:B100,2,False)

:-)

Dave Hawley · Mar 13, 2004

Thanks Frank, well spotted!

I will purposely posting some more erroneous replies, at some stage, to
test others

)

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Frank Kabel · Mar 13, 2004

Dave said:
Thanks Frank, well spotted!

I will purposely posting some more erroneous replies, at some stage,
to test others )

Hi Dave
I think we all do this - of course always only to test others <vbg>

wish you a nice weekend
Frank