|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2010, 01:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I combine a Vlookup with an IF formula?
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 
|
|
#2
April 15th, 2010, 01:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I combine a Vlookup with an IF formula?
Hi,
let' say you want to perform the vlookup if cell A1 is greater than 100, if not will leave the cell blank =if(A1100,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
|
|
#3
April 15th, 2010, 01:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
