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
|