Julian,

basicaly, without using VB code, you cannot 'put' something into
another cell, the formula must be within the cell and the result of the
formula is shown within the cell.

You can, however, use two VLookups, one in each cell.

=vlookup(item,tablerange,2,false)
and
=vlookup(item,tablerange,3,false)

Hope this helps



Julian Campbell Wrote:
Hello all,

I have set up a vlookup with help from this group.

I wonder if I can use vlookup to return 2 entries, each into seperate
cells

1 2
3

A SELECT RETURN VAL 1 RETURN VAL 2
PRODUCT PRODUCT CODE PRODUCT PRICE

Thanks again for your help

Julian


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=470077