Look Up Table in Excel

[paul bennett]

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]

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

 

[Dave Peterson]

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]

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]

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

 

[Dave Hawley]

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]

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