Hello,

A3 contains a Vlookup and I do not know how to link it to a formula to show
the value in A3 if the following conditions are met:

Example: In cell H1 I need something like:
=IF(A3="AVB",A3,IF(A3="JDR",A3,IF(A3="GVB",A3)))

Hope you can Help

Thank you ! Arno

In Hi enter:
=A3

Your if-structure offers no alternative to using A3
--
Gary''s Student - gsnu200816


"Arno" wrote:

Hello,

A3 contains a Vlookup and I do not know how to link it to a formula to show
the value in A3 if the following conditions are met:

Example: In cell H1 I need something like:
=IF(A3="AVB",A3,IF(A3="JDR",A3,IF(A3="GVB",A3)))

Hope you can Help

Thank you ! Arno

Hi Gary,

I tried to enter =A3 but it shows only False or True and I need the actual
name in the A3 example JDR. I guess the Vlookup is preventing it

Any suggestion - Thanks

"Gary''s Student" wrote:

In Hi enter:
=A3

Your if-structure offers no alternative to using A3
--
Gary''s Student - gsnu200816


"Arno" wrote:

Hello,

A3 contains a Vlookup and I do not know how to link it to a formula to show
the value in A3 if the following conditions are met:

Example: In cell H1 I need something like:
=IF(A3="AVB",A3,IF(A3="JDR",A3,IF(A3="GVB",A3)))

Hope you can Help

Thank you ! Arno

Me again, to better explain if I write:

=IF(A3="NDE",A3) Instead of NDE I get FALSE This is my problem

Thanks

"Gary''s Student" wrote:

In Hi enter:
=A3

Your if-structure offers no alternative to using A3
--
Gary''s Student - gsnu200816


"Arno" wrote:

Hello,

A3 contains a Vlookup and I do not know how to link it to a formula to show
the value in A3 if the following conditions are met:

Example: In cell H1 I need something like:
=IF(A3="AVB",A3,IF(A3="JDR",A3,IF(A3="GVB",A3)))

Hope you can Help

Thank you ! Arno

Hi Gary,

I wanted to keep it short but probably it is better if I write the whole
question:

A3 has a name, depending on which name I need the if function in my cell to
multiply the value by the exchange rate - USD to EURO

A3 contains a Vlookup that does not allow to return the name I need to
establish if the formula can convert the value into EURO


"Arno" wrote:

Me again, to better explain if I write:

=IF(A3="NDE",A3) Instead of NDE I get FALSE This is my problem




Thanks

"Gary''s Student" wrote:

In Hi enter:
=A3

Your if-structure offers no alternative to using A3
--
Gary''s Student - gsnu200816


"Arno" wrote:

Hello,

A3 contains a Vlookup and I do not know how to link it to a formula to show
the value in A3 if the following conditions are met:

Example: In cell H1 I need something like:
=IF(A3="AVB",A3,IF(A3="JDR",A3,IF(A3="GVB",A3)))

Hope you can Help

Thank you ! Arno