J
Joe
If I want to get the result from the first table instead of the second one.
Wot can I do?
Wot can I do?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
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
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
J
Joe
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
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
P
Pete_UK
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
=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