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

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

Thanks for your response, it has to only return one entry, so it has to
lookup all cells but only return what entry is in cell, it has to be or not
all of data.

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

But this does not work.

Any other ideas.

Thanks


Mark

"Patrick Molloy" wrote:

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

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

Can you have a look at the following code, I am trying to enter but getting
an error with formula

=IF(ISNA(VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE)),VLOOKUP('Kelso
Resources'!E10,C25:G25,5,FALSE)),VLOOKUP('Kelso
Resources'!D14,C25:G25,3,false)),VLOOKUP('Kelso
Resources'!D18,C25:G25,4,false)),VLOOKUP('Kelso
Resources'!D24,C25:G25,3.false)),VLOOKUP('Kelso
Resources'!D28,C25:G25,2,false)),VLOOKUP('Kelso
Resources'!E30,C25:G25,5,false)),VLOOKUP('Kelso
Resources'!D34,C25:G25,4,false)),VLOOKUP('Kelso Resources'!D8,C25:G25,2,FALSE)

Many thanks


Mark

"Bernard Liengme" wrote:

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