Essentially you could put 2 separate lookups in one cell, something like
this, assumes that the criteria to use as the basis for both lookups is in
cell A1 of the sheet this is on (call it Sheet3)

=VLOOKUP(A1,Sheet1!TableRange,3,False) & " | " & VLOOKUP(A1,
Sheet2,Table2Range,7,False)

you'd get the results of the 2 lookups separated by a bar like
Mary | Lamb
presuming "Mary" and "Lamb" are results available in the tables on sheets 1
and 2. You could do other operations besides just concatenating strings,
like addition, multiplication, etc. The results of the VLOOKUP()s just get
treated like any other reference.

"Afolabi" wrote:

Please I need a vlookup formula that could look up a value from 2 different
worksheets. any help?