View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Can I combine a Vlookup with an IF formula?

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