View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Link an IF formula with a cell containing a Vlookup formula

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