Untested - please double check parentheses:
=IF(ISNA(VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE)),VLOOKUP('Kelso
Resources'!E10,C25:G25,5,FALSE), VLOOKUP('Kelso
Resources'!D8,C25:G25,2,FALSE)))
If the D8 lookup fails, use the E10 lookup
If both fail you will get #N/A
Avoid this with
=IF(ISNA(VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE)),
IF(ISNA(VLOOKUP('Kelso Resources'!E10,C25:G25,5,FALSE),"Neither"
,VLOOKUP('Kelso Resources'!E10,C25:G25,5,FALSE))),
VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE)))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"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