you can concatenate ---

=VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE) & VLOOKUP('Kelso
Resources'!E10,C25:G25,5,FALSE)


"terilad" wrote in message
...
Hi is there a way to add multiple VLOOKUP to one cell like below.

=VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE) and add this to the cell as
well VLOOKUP('Kelso Resources'!E10,C25:G25,5,FALSE)

Many thanks


Mark