MrExcel Publishing
Your One Stop for Excel Tips & Solutions

looking up a value thas a colom accross from data already looked up

Posted by CHRIS on February 14, 2001 6:25 AM

How would i use a macro or an excell function to look up 2 values simultaniosly in a database? what i want it to look up is a bookname then the price of that book?

Posted by Mark W. on February 14, 2001 6:54 AM

A Database function such as DGET might work, but
you need to provide more information about your
database including the uniqueness of its records.

Posted by Dave Hawley on February 14, 2001 7:15 AM

Hi Chris

If I have understood you then a simple VLOOKUP should work
=VLOOKUP("War and Peace",A1:F200,3,FALSE)

Where "War and Peace" is the book, A1:F200 is the table of data, and 3 is the third Columns arcoss from Column A which contains the book names. False is find an exact match.

DaveOzGrid Business Applications

Posted by Mark W. on February 14, 2001 7:30 AM

Dave, I believe he wants to return 2 values -- a
bookname and it's price. Using VLOOKUP() that would
necessitate an array constant as the 3rd argument.
I'm still uncertain about his lookup value. If
it's the bookname (as you suspect) then why would
Chris want to return a value that he already has?
Questions, questions, questions... the devil is
always in the details.

Posted by CHRIS on February 15, 2001 4:14 AM

well its is a table of containing bookname, isbn number, book value, publisher and dte of publication.

what i want to do is to find out how much a book cost after ive enterd the name into a cell i want it to return the book price into the cell next to it

sorrey if what i said wasnt clear

Posted by Mark W. on February 15, 2001 5:41 AM

See Dave's response above.