Prev: Setting up an electrical register in Excel with expiry dates
Next: Help with If Sum statement - i think....
From: Claire CMB on 15 Apr 2010 08:30
I'm not sure Excel can do what I want it to do -

I have a VLookup formula on my spreadsheet which is returning data, however,
I only want it displayed if it returns a specific condition.
Is this possible ?
--
CMB BT
From: Eduardo on 15 Apr 2010 08:33
Hi,
let' say you want to perform the vlookup if cell A1 is greater than 100, if
not will leave the cell blank

=if(A1>100,your formula,"")

"Claire" wrote:

> I'm not sure Excel can do what I want it to do -
>
> I have a VLookup formula on my spreadsheet which is returning data, however,
> I only want it displayed if it returns a specific condition.
> Is this possible ?
> --
> CMB BT
From: Duke Carey on 15 Apr 2010 08:35
try something like this:

=if([your vlookup formula]=[your condition],[your vlookup formula],"")

replace the bracketed items with your actual formula and condition

"Claire" wrote:

> I'm not sure Excel can do what I want it to do -
>
> I have a VLookup formula on my spreadsheet which is returning data, however,
> I only want it displayed if it returns a specific condition.
> Is this possible ?
> --
> CMB BT
 | 
Pages: 1
Prev: Setting up an electrical register in Excel with expiry dates
Next: Help with If Sum statement - i think....