If I want to get the result from the first table instead of the second one.
Wot can I do?

You may need to clarify that with an example of your data layout but if by
table you mean from a different Column then consider this

=VLOOKUP(A1,J1:N18,2,FALSE)

The table array in the above is 5 columns wide and the column to return is
set by the 2 in the formula which can be any of the 5 columns.

Mike

"Joe" wrote:

If I want to get the result from the first table instead of the second one.
Wot can I do?

Hi Mike,

I meant to post this to my previous question but apparantely I am having
problems using the web-link at work.

Assume that I have two tables for the same data but from two different
systems. The original idea is to substract data from Table A from Tabel B by
using Vlookup.

However, the some of the headings may be missing from one of the tables.
Therefore, the result is #N/A.

To prevent this I am now using =ISNA. But I would like to have a formula so
when one of the values is missing in one of the tables, it brings just the
value from one of the tables

Thanks,
jose

"Mike H" wrote:

You may need to clarify that with an example of your data layout but if by
table you mean from a different Column then consider this

=VLOOKUP(A1,J1:N18,2,FALSE)

The table array in the above is 5 columns wide and the column to return is
set by the 2 in the formula which can be any of the 5 columns.

Mike

"Joe" wrote:

If I want to get the result from the first table instead of the second one.
Wot can I do?

Use something along these lines:

=IF(ISNA(vlookup_1),IF(ISNA(vlookup_2),"not
present",vlookup_2,vlookup_1))

where vlookup_1 and vlookup_2 are your VLOOKUP formulae looking at
table_1 and table_2 respectively. So, if it is not present in table_1
then look in table_2 - if it is not present in either then return that
message.

Hope this helps.

Pete

On Jan 23, 7:02*pm, Joe wrote:
Hi Mike,

I meant to post this to my previous question but apparantely I am having
problems using the web-link at work.

Assume that I have two tables for the same data but from two different
systems. The original idea is to substract data from Table A from Tabel B by
using Vlookup.

However, the some of the headings may be missing from one of the tables.
Therefore, the result is #N/A.

To prevent this I am now using =ISNA. But I would like to have a formula so
when one of the values is missing in one of the tables, it brings just the
value from one of the tables

Thanks,
jose



"Mike H" wrote:
You may need to clarify that with an example of your data layout but if by
table you mean from a different Column then consider this

=VLOOKUP(A1,J1:N18,2,FALSE)

The table array in the above is 5 columns wide and the column to return is
set by the 2 in the formula which can be any of the 5 columns.

Mike

"Joe" wrote:

If I want to get the result from the first table instead of the second one.
Wot can I do?- Hide quoted text -

- Show quoted text -